Stored procedure parameters

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table

Dynamic creation of Insert, Update, Delete Stored procedures

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table

DROP all stored procedures

This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.

Search All Stored Procedures in a Database

Search for a text in all the stored Procedures in a Database

Performance testing and tuning for a beginner

How to test and tune a stored procedure?

Find a Table's Metadata

Stored Procedure that returns table information

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.

Search word in sps

Get the list of sps or functions having a word e.g. "Return"

Searching Objects for Text

When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.