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!