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 38    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,355 reads

usp_tableReference

Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.  Read more...
By Ankush Parab 2013/08/12 | Source: SQLServerCentral.com | Category: sp_depends
Rating: |  Discuss |   Briefcase | 1,053 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/10/09 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 2,300 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/10/01 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,938 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,191 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,883 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,555 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,822 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,025 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,797 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,758 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 | 767 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,062 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,164 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,583 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,655 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,103 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,871 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,036 reads
   Items 1 to 20 of 38    Older >>