Click here to monitor SSC
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 12 of 12   
 

Change Stored Procedure Automaticly

Script describe How to change stored procedure Automaticly.  Read more...
By ESAT ERKEC 2016/11/22 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 527 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 | 892 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,171 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,471 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,727 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,524 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,883 reads

Database_Object_Last_used_details

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,311 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,089 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,631 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 | 780 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,310 reads
   Items 1 to 12 of 12