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

Snooping around in the Installation Scripts

Another good source of undocumented information is the set of installation scripts that ship with SQL Server. You can find these scripts in the Install folder under your root SQL Server installation. You can conduct the same sorts of searches against these scripts that we used with syscomments to find undocumented trace flags, DBCC commands, stored procedures, user-defined functions, and the like. For example, I discovered how to create my own INFORMATION_SCHEMA views (and documented the process in my last book) by examining ansiview.sql. I figured out how to create my own system functions by examining instdist.sql. There's a wealth of undocumented information to be had by examining the scripts that ...

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