SQL scripts. Free to use, but you use at your own peril.
The procedures can be installed by deploying the Master.DB.Extensions project. It is recommended you deploy with the publish profile.
| Script or Procedure | Description |
|---|---|
| CDC - Add new columns to CDC capture.sql | Script to allow objects participating in change data capture (CDC) to have the new columns added to CDC. |
| sp_foreignkeys2 | Reports foreign key information about the supplied table. A little bit easier to read/consume than the sp_help output IMHO |
| sp_helpfile2 | Alternative to sp_helpfile. Adds size information to the output |
| sp_helpindex2 | Alternative to sp_helpindex. Provides the include columns in the output and index usage statistics |
| sp_trust_foreignkeys | Steps over non trusted foreign keys and runs ALTER TABLE...WITH CHECK CHECK against them |
| sp_useroptions | Decodes the @@options values into a table |