Scripting SQL Server


SQL Server Migration Toolkit - There is host of useful TSQL for scripting core SQL Server objects in the Migration Toolkit section

Pivoting Rows into Columns - Pivot column values from multiple rows into a single delimited cell.

Auto-Create Call SP TSQL Templates - Auto-create TSQL templates for invoking all SPs in a database

Auto-Create Insert Into Table TSQL Templates - Auto-create TSQL templates for inserting into all tables in a database

Auto-Create Update each Table TSQL Templates - Auto-create TSQL templates for updating all tables in a database

Auto-Create Select from Table TSQL Templates - Auto-create TSQL templates for selecting from all tables in a database

Auto-Create Select from TVF TSQL Templates - Auto-create TSQL templates for selecting from all table-valued functions in a database

Expand all TABs in a String to Spaces - Replace all TABs in a string with spaces

Generate a descriptive list of SQL Agent jobs - Retrieve a compact list of SQL Agent jobs with a decoded (ie readable) schedule string