Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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

<< Newer    Items 21 to 28 of 28   
 

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

SQL 2008 : Uncompressed Objects Procedure

A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.   Read more...
By Richard Doering 2010/12/22 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 700 reads

Cluster Information

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources  Read more...
By Rudy Panigas 2009/05/08 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 1,303 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,429 reads

Change Ownership of a Maintenance Plan

Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.   Read more...
By Phill Carter 2008/12/12 | Source: SQLServerCentral.com | Category: ownership
Rating: |  Discuss |   Briefcase | 2,954 reads

Invalid SKU Error when Adding a Node to a SQL 2008 Cluster

When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error  Read more...
By Ysaias Portes 2008/09/07 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 3,071 reads

SQL Server 2008 index fragmentation

Script to see how fragmented the indexes are.  Read more...
By BarryK 2008/05/15 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 3,193 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,584 reads
<< Newer    Items 21 to 28 of 28