Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Stored Procedures Rss

Search for any content tagged stored procedures

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 37    Older >>
 

Find the most executed stored procedure(s)

Find the most executed stored procedure(s).  Read more...
By Mehernosh 2013/08/30 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,273 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/02/26 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 1,556 reads

Stored Procedures Performance

This script summarizes the execution statistics of the stored procedures which was run on the current database in the last 7 days.  Read more...
By Adnan Korkmaz 2014/01/01 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 5,143 reads

System Proc sp_SysMon to monitor sql server health

I created as a system proc but it can be executed individually. It will print some system health counters.  Read more...
By Gokhan Varol 2012/01/31 | Source: SQLServerCentral.com | Category: system health
Rating: |  Discuss |   Briefcase | 2,159 reads

ITX_SP_BAK

Creates a single sql install file for all stored procs in a database.  Read more...
By Sean Brian 2011/10/14 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 509 reads

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  Read more...
By Partha Pal 2011/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,864 reads

Stored procedure to script out user permissions

Stored procedure to script out user permissions  Read more...
By Harsha Majety 2011/01/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 4,375 reads

SP and function dependencies

Extracts all calls to SPs and functions (down to depth of 32)  Read more...
By Peter Sloboda 2010/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,817 reads

Get default values of parameters in stored procedures

Helps to get the default value of parameters from stored procedures and functions.   Read more...
By Atif-ullah Sheikh 2010/06/22 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,003 reads

Slow SP with date parameters solved.

when you use datetime parameters in SPs in the where clause the SP becomes very slow  Read more...
Rating: |  Discuss |   Briefcase | 2,790 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,730 reads

Generate stored procedure parameter list based on table order by table

this script does the same as the one publish on 04-12-2009 plus add the number of table you need and it will be sort by table name and ordinal position.  Read more...
Rating: |  Discuss |   Briefcase | 763 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,049 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,142 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,560 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,636 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads

Execute SQL Scripts in paralel for real performance tests

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.  Read more...
By Gustavo Maia 2009/09/30 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,846 reads

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  Read more...
By Samardeep Khera 2009/08/12 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,023 reads

Using Coalesce in a stored Procedure

A quick way to take a column of data and place it into a variable in a Stored Procedure in a comma, separated format.  Read more...
By Richard Spalding 2009/06/26 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,822 reads
   Items 1 to 20 of 37    Older >>