>>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