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