Talking about SQL SERVER – 2005 – List all the database « Journey to SQL Authority with Pinal Dave

  —-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
    
—-SQL SERVER Un-Documented Procedure
EXEC sp_msForEachDB ‘PRINT ”?”’

 
 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s