Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag SQL Server 2008 Rss

Search for any content tagged sql server 2008

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 20 of 27    Older >>
 

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...
By Greg Ryan 2014/04/15 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 1,637 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: SQLServerCentral.com | Category: schemas
Rating: |  Discuss |   Briefcase | 1,232 reads

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2014/08/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 927 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...
Rating: |  Discuss |   Briefcase | 1,565 reads

Logshipping Backup Files Management

Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.  Read more...
By Vaibhav Mehta 2012/06/28 | Source: SQLServerCentral.com | Category: logshipping
Rating: |  Discuss |   Briefcase | 577 reads

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,551 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
Rating: |  Discuss |   Briefcase | 927 reads

sp_JobSchedule_rpt for SQL 2005/8

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.   Read more...
By Sekhar Mynam 2012/02/23 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,310 reads

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,903 reads

Detach All User Databases

Detach all user databases on a SQL 2008 instance  Read more...
By Chris McGowan 2011/08/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 883 reads

Check status of active transactions

Script to check status of active transactions.  Read more...
By Harsha Majety 2011/08/04 | Source: SQLServerCentral.com | Category: status
Rating: |  Discuss |   Briefcase | 2,173 reads

SQL DBAdmin toolbox - Part 1: Restore single database

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,438 reads

Kill all connection to database

Procedure tries to kill all connections to the specified database.  Read more...
By Rafal Skotak 2011/03/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,851 reads

Backup Compression Ratio

Display's backup compression ration for SQL 2008 (Enterprise or Developer)  Read more...
By Gregory Ferdinandsen 2010/08/31 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,036 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,740 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,512 reads

Script to Compress Tables and Indexes

This script creates scripts to compress all tables and indexes in a database.   Read more...
By Jeremy Egbert 2010/01/04 | Source: SQLServerCentral.com | Category: compress
Rating: |  Discuss |   Briefcase | 4,023 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,644 reads

Scripts for Full DB Compression at partition level

Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.   Read more...
By Jay Rajgor 2009/11/18 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 1,038 reads

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.  Read more...
By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 915 reads
   Items 1 to 20 of 27    Older >>