O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The syscomments Gold Mine

A bountiful source of undocumented features, commands, functions, and syntax can be found in the syscomments system table. The syscomments table is where the source code to every procedural object—every stored procedure, trigger, view, user-defined function, default, and rule object—in a database is stored. Each database has its own copy of this table. I'm especially fond of the syscomments tables in master, msdb, and the replication distribution databases. I've also found undocumented features hiding in replication-generated stored procedures, views, and triggers in publication or subscription databases.

Undocumented DBCC Commands

I've found a gold mine of undocumented commands by snooping around in master..syscomments. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required