SQL SERVER – 2005 – List all the database | Journey to SQL Authority with Pinal Dave

List all the database on SQL Servers. All the following Stored Procedure list all the Databases on Server. I personally use EXEC sp_databases because it gives the same results as other but it is self explaining. ----SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005 SELECT… Continue Reading...

Source: SQL SERVER – 2005 – List all the database | Journey to SQL Authority with Pinal Dave