Hi,<BR><BR>I want to know a way to get all the database names in SLQ Server 2000... I cannot find it anywhere..<BR><BR>Thanks in advance!<BR>Joris Keeman
sp_databases stored procedure
<BR><BR>select name from master.dbo.sysdatabases<BR> where has_dbaccess(name) = 1
being really pedantic, but you shouldn't query the systables.<BR><BR>Use the INFORMATION_SCHEMA views instead.
I just cut & paste it from the built-in Microsoft stored procedure.