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

CROSS APPLY and OUTER APPLY in SQL Server

In this article, we are learning the use of the CROSS APPLY

How to get notification from database when any transaction on records?

Technologies Used: Visual Studio 2013 Express Sql Server 2008 R2 Express MVC 5 Nuget SqlDependency MSDN SignalR

Get record count of large or locked tables in MSSQL

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

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