Categories
SQL Server

SQL SERVER – 2005 – List all the database

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

Related posts:

  1. Five Database Design Errors To Avoid Source: Simple-Talk Common Lookup Tables Always use separate tables for...
  2. SQL 2005 Stored Procedures Last Modify Date USE Database --Change to the database you want to use...
  3. SQL Server Security: Database “db_datareader” Roles The db_datareader role The db_datareader role has the ability to...
  4. Drop Down List Client & Server Side event Helpful post I found for handling client & server side...