>>>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.
If it's not broken, fix it until it is.
My Blog