Guru's Guide to SQL Server Architecture and Internals, The

Goodies in sysobjects

The sysobjects system table exists in every database and contains a row for every object in the database. If you have some idea of the name or type of an undocumented object, you can check for its existence in Enterprise Manager's navigation tree and in Query Analyzer's Object Browser. You can also query sysobjects directly to get this information, which is where Enterprise Manager and Query Analyzer ultimately get it. The code below queries sysobjects directly for simplicity's sake.

Undocumented Extended Procedures

Extended procedures must reside in the master database and are usually prefixed with xp_. Here's a sysobjects query that returns the name of the extended procedures registered in the master database:

 SELECT ...