<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
Stored Procedures
Search for
any
content tagged
stored procedures
Add a script
Items 1 to 20 of 36
Next 20 >>
Unused Input Parameters
Identify all objects containing unused input parameters.
Read more...
By
Sean Smith
2012/12/19
|
Source:
SQLServerCentral.com
|
Category:
unused
Rating:
|
Discuss
|
Briefcase
|
714 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
2012/05/07
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
3,271 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,013 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
|
494 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,737 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
|
3,801 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,768 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
|
1,891 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...
By
Virgilio Licovali Bustos Ramirez
2010/04/28
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
2,749 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,633 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...
By
Lebrasseur Jean-Pierre
2009/12/28
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
738 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,000 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,099 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,495 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,534 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,048 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,752 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
|
1,923 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,790 reads
Stored Procedure to maintain RSExecutionLog
An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft
Read more...
By
Perry Dyball
2010/05/21
|
Source:
SQLServerCentral.com
|
Category:
rsexecutionlog
Rating:
|
Discuss
|
Briefcase
|
1,612 reads
Items 1 to 20 of 36
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
