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

Scripts with tag Scripts Rss

Search for any content tagged scripts

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

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 | 884 reads

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/14 | Source: | Category: scripts
Rating: |  Discuss |   Briefcase | 672 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: | Category: scripts
Rating: |  Discuss |   Briefcase | 1,727 reads

Grouped Failover, a 2008R2 version of Availability Groups

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.  Read more...
By Remko de Boer 2013/01/24 | Source: | Category: scripts
Rating: |  Discuss |   Briefcase | 536 reads

Find data difference between two datasets

Find data difference between two datasets 
By Atif-ullah Sheikh 2010/10/04 | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,840 reads
   Items 1 to 5 of 5