Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

<< Newer    Items 41 to 60 of 3355    Older >>
 

Replication-Quick way to determine the articles

Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.  Read more...
By Koushik Roy 2016/06/06 | Source: SQLServerCentral.com | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 314 reads

Table Comparison Procedure

Procedure to compare two tables , getting table names and rows to display  Read more...
By Sheraz Mirza 2016/06/07 | Source: SQLServerCentral.com | Category: table data comparison
Rating: |  Discuss |   Briefcase | 806 reads

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names  Read more...
By John Rogerson 2016/06/03 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 280 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 536 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 442 reads

Database Information

this script returns some good information about databases on an instance of SQL SERVER.  Read more...
By Rajesh Sharma 2016/05/05 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Query to find tables with Forwarded Records

Use below query to find tables that need to be optimized based on number of forwarded records.  Read more...
By Ajay Dwivedi 2016/06/16 | Source: SQLServerCentral.com | Category: optimization
Rating: |  Discuss |   Briefcase | 425 reads

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.  Read more...
By Haden Kingsland (theflyingdba) 2016/06/09 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 639 reads

Write to File

Stored procedure that writes @Text out to @File  Read more...
By Andie Letourneau 2016/06/14 | Source: SQLServerCentral.com | Category: ole
Rating: |  Discuss |   Briefcase | 828 reads

Script to Find String in Database object

Script that searches every object in a database for a specific string.  Read more...
By Andie Letourneau 2016/06/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 702 reads

Space monitor on SQL Server

monitoring over server spacing  Read more...
By Jignesh Raiyani 2016/06/08 | Source: SQLServerCentral.com | Category: space monitoring
Rating: |  Discuss |   Briefcase | 638 reads

Agent Job Schedule Description

Yet another schedule description query with added grammatical improvements.  Read more...
By Michael McCormick 2016/05/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 544 reads

Brute Force data search tool

searches entire db for a string, number, or date, returns list of results  Read more...
By John Imel 2016/05/02 | Source: SQLServerCentral.com | Category: bruteforce
Rating: |  Discuss |   Briefcase | 838 reads

Restore script for Ola Hallengren backup

Create a restore script based on backup files in a directory  Read more...
By Joe O'Connor 2016/05/03 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 632 reads

DBCC CHECKDB to a table

An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 565 reads

SQL server Agent - Status

As part of the application to monitor SQL health I created. The procedure returns status of the SQL server Agent  Read more...
By Kraai 2016/04/29 | Source: SQLServerCentral.com | Category: sql server agent .
Rating: (not yet rated) |  Discuss |   Briefcase | 506 reads

Get Space on SQL hardrive

I was recently asked to monitor the Database size on the SQL server, and display the results in a report.   Read more...
By Kraai 2016/05/05 | Source: SQLServerCentral.com | Category: space on hardrive
Rating: |  Discuss |   Briefcase | 667 reads

Pad length

Pad string with a lenght of characters at front or back  Read more...
By Kraai 2016/04/28 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 440 reads

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.  Read more...
By Alan Burstein 2016/04/27 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 819 reads

Database File Move Etc

A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts  Read more...
By M Higgins 2016/04/20 | Source: SQLServerCentral.com | Category: attach
Rating: |  Discuss |   Briefcase | 470 reads
<< Newer    Items 41 to 60 of 3355    Older >>