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

Scripts with tag SQL Server 2005 Rss

Search for any content tagged sql server 2005

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 122    Older >>
 

Create tables and indexes with a Store Procedure

If you want to get the CREATE TABLES for all your Database tables, now you just need to run this SP.  Read more...
By Dario Palladino 2013/11/27 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,611 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,543 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 | 548 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 911 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,298 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,874 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,120 reads

Merge Tables in SQL 2005

To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005  Read more...
By rka 2011/06/15 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,287 reads

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...
By Rich Yarger 2011/03/14 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 2,068 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,813 reads

Find data difference between two datasets

Find data difference between two datasets  Read more...
By Atif-ullah Sheikh 2010/10/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,672 reads

Way to Check Multiple LIKE without dynamic SQL

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...
By Atif-ullah Sheikh 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,442 reads

Retreive the Schema of a Stored Procedure or Function

This script shows you code that retrives schema of a routine (Stored procedure or a function).   Read more...
By Anthony peiris 2010/09/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,915 reads

Count Number of Words and Characters

Count Number of Words and Characters  Read more...
By Atif-ullah Sheikh 2010/07/27 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,062 reads

Parsing / breaking character separated values in a table in one query

At times, we have situation to parse the character separated string in the table column.   Read more...
By Atif-ullah Sheikh 2010/07/14 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 2,088 reads

get schedule description

workaround the bug in msdb..sp_get_schedule_description  Read more...
By Matthias Kroll 2010/04/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,490 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,480 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,616 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files  Read more...
By Luan Moreno M. Maciel 2009/11/03 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,884 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,296 reads
   Items 1 to 20 of 122    Older >>