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

Add a script

   Items 1 to 20 of 117    Next 20 >>
 

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: (not yet rated) |  Discuss |  Briefcase | 1,120 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 | 1,459 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,071 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 | 1,815 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,374 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,367 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,214 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,824 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 | 1,833 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 | 1,943 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,261 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,026 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,397 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,760 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,177 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 989 reads

BCP Format File Builder

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.  Read more...
By Paul Hunter 2009/08/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |  Briefcase | 1,689 reads

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table  Read more...
By Samardeep Khera 2009/08/12 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |  Briefcase | 1,781 reads

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005  Read more...
By Sandesh Segu 2009/08/04 | Source: SQLServerCentral.com | Category: table search
Rating: |  Discuss |  Briefcase | 980 reads

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns, indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.  Read more...
Rating: (not yet rated) |  Discuss |  Briefcase | 638 reads
   Items 1 to 20 of 117    Next 20 >>