>>>>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
>
>To get differences between 2 versions of databases try SQLCompare from Red-Gate. They come with trial version.

Thanks Naomi I'll take a look.