Share via

SQL Server Undocumented Stored Procedure - sp_MSForEachDB

  • Article

This wiki page is about an undocumented stored procedure sp_MSForEachDB.

A more detailed list of undocumented stored procedures is at the following wiki -
http://social.technet.microsoft.com/wiki/contents/articles/16975.sql-server-undocumented-stored-procedures.aspx

It is strongly recommended to avoid using undocumented features of SQL Server in your Production environment.

How to exclude databases while using the sp_MSforeachdb stored procedure
http://www.sqlservercurry.com/2010/01/how-to-exclude-databases-while-using.html

6 Common Uses of the undocumented Stored Procedure sp_MSforeachdb
http://www.sqlservercurry.com/2009/04/6-common-uses-of-undocumented-stored.html

  1. Print all the database names in a SQL Server Instance
  2. Print all the tables in all the databases of a SQL Server Instance
  3. Display the size of all databases in a SQL Server instance
  4. Determine all the physical names and attributes(size,growth,usage) of all databases in a SQL Server instance
  5. Change Owner of all databases to 'sa'
  6. Check the Logical and Physical integrity of all objects in the database