How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
A step by step tutorial to create a T-SQL script that can copy database schema and all objects, like stored procedures, functions, triggers, tables and views.
Refactoring a Long Stored Procedure Into Readable Steps
Learn refactoring a long stored procedure with output baselines, named temp tables, dead-code removal, and two-way EXCEPT checks before release.
Writing Clear Error Messages in Procedures
Clear error messages in procedures identify the failed operation, useful keys, and next action without exposing sensitive data.
SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
How to copy data from one table to another without a cursor: INSERT INTO SELECT for an existing table, or SELECT INTO to create a new table.
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
A simple script on sys.objects that shows the stored procedure create date and modified date, handy for audits and for watching changes to your objects.
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
DDL triggers fire when someone changes the schema. How to write one, what EVENTDATA gives you, and how to get back in if one locks you out.