E-Mail:
Get our new Windows 7 eBook (PDF) for $7 with 70+ Tips. Download Now!

SQL Server 2005 Undocumented Stored Procedures!

Today I was searching the internet for an easier way to see if a file exists. As I was searching I came across several undocumented SQL Server 2005 procedures. They are:

  • xp_fileexist
  • sp_MSforeachdb
  • sp_msforeachtable
  • sp_msdependencies

Now knowing that these undocumented extended and stored procedures exist, they will definitely make my job a lot easier. The source that I found these undocumented procedures are at SQL Server Central. Since this is SQL Server Central you will need to create a free user account (if you do not already have one) to see the details of the undocumented procedures.

If you know of other undocumented procedures please share them here!

What Do You Think?

 

Posted Recently

40 queries / 0.171 seconds.