consolidated script generator for multiple stored procedures

Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go

Changing Text in Multiple Stored Procedures From a Stored Procedure

In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.

Stored procedure to script out user permissions

Stored procedure to script out user permissions

True or False

SP and function dependencies

Extracts all calls to SPs and functions (down to depth of 32)

Stored Procedure Execution

Get default values of parameters in stored procedures

Helps to get the default value of parameters from stored procedures and functions.

Slow SP with date parameters solved.

when you use datetime parameters in SPs in the where clause the SP becomes very slow

Optimization

Auto-Execute Procs