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

Simple way to generate connection string from text file

Common issue generally every developer faces in his initial days of development

SQL NULL Value – Simplified

In SQL, NULL approximately represents an unknown value.An arithmetic operation involving a

T-SQL Query Optimization in MS SQL Server, The all important WHERE clause

As an T-SQL Developer, we always tend to wonder why my query

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="">