List all the databases on SQL Server
May.05, 2009 in
SQL Server
List all the database on SQL Servers.
—-SQL SERVER 2005 System Procedures
EXEC sp_databases
EXEC sp_helpdb
—-SQL 2000 Method still works in SQL Server 2005
SELECT name
FROM sys.databases
SELECT name
FROM sys.sysdatabases
Leave a Reply
You must be logged in to post a comment.