>>Hi
>>
>>What sql command will list all the databases on a server for me.
>>I want to copy the list to a file so I can arrange some tidying up by getting people to identify whats to be kept and whats to go.
>>
>>Thanks
>>
>>Nick
>>
>>Its ok I found it.
>>
>>EXEC sp_helpdb
>
>

>SELECT * FROM sys.databases 
>

Thanks Boris

a supplementary question

how to list views, tables and stored procedures.

Or how to list differences between two databases.

(In this case its a package and would like to know the differences between the virgin as installed package and the altered/customised version)

Nick