I created as a system proc but it can be executed individually. It will print some system health counters.  Read more...

SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.   Read more...

Creates a single sql install file for all stored procs in a database.  Read more...

Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.   Read more...

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

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.  Read more...

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...

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

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

Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.  Read more...

Stored procedure to script out user permissions  Read more...

Read more...

How to test and tune a stored procedure?  Read more...

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

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

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

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

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...

Read more...

Pass variables values from Stored Procedures to Trigger  Read more...