SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Stored Procedure Rss

Search for any content tagged stored procedure

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 13 of 13   

Find UDF useage

Find all stored procedures that use UDFs 
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 297 reads

Change Stored Procedure Automaticly

Script describe How to change stored procedure Automaticly. 
By ESAT ERKEC 2016/11/22 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 658 reads

End to End Server Disk Space reporting within SQL Server

This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!  Read more...
Rating: |  Discuss |   Briefcase | 919 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2015/02/17 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,174 reads

SP Send Query Result as HTML table using DBMail

Create a stored procedure that will send the result of a query as an html table from the database mail.  Read more...
By Dave Gugg 2015/03/26 | Source: SQLServerCentral.com | Category: db_mail
Rating: |  Discuss |   Briefcase | 3,500 reads

Universal foreach aka sp_uforeach

This script is a universal foreach stored procedure. You can loop through everything with the help of if.  Read more...
By Robert Virag 2013/09/24 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 1,731 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2015/04/10 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,525 reads

Last Accesses Stored Procedure

List of your Stored Procedures and when they were last accesses.  Read more...
By Jason Clements 2012/10/25 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,886 reads


I have implemented following stored procedure which is providing the object wise last used date of all databases which is available in single instance.  Read more...
By Abhijit Shedulkar 2012/09/12 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,314 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...
By Derek Colley 2012/08/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,091 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,638 reads

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.  Read more...
By David Hay 2009/08/17 | Source: SQLServerCentral.com | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 782 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2014/09/09 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 4,313 reads
   Items 1 to 13 of 13