Home > Database > MS SQL Server > SQL SERVER – List all the database

SQL SERVER – List all the database

Vivek More MS SQL Server 0

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 ”?”’

This Article is TAGGED in , , , , . BOOKMARK THE permalink.

Avatar photo
Vivek More

Related articles

How to Store session in database

Step 1: Execute below query at your database: [crayon-69cf77ef60534163087873/] Step 2: Add following line your

Get record count of large or locked tables in MSSQL

Ever wondered why it takes so much time to get the count

DDL, DML, DCL, DQL and TCL Commands – Meaning and Keywords in SQL

SQL - Structured Query Language is further categorized on the basis of

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">