Friday 19 April 2013

How to list all the databases in SQL Server

To list all the databases in SQL Server 2005 or 2008 use one of the following Stored Procedures:
EXEC sp_databases
or
EXEC sp_helpdb

No comments:

Post a Comment