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


Check all sys views in BOL

SELECT * FROM sys.tables
SELECT * FROM sys.views 
SELECT * FROM sys.procedures