Restore 2000 DB to 2005

This script was designed to restore a backup of a SQL Server 2000 database from disk file to SQL Server 2005.Unfortunatelly the RESTORE will leave land mines for you to find the hard way, this script was updated to fix all that I have found:Change CONCAT_NULL_YIELDS_NULL ON, PAGE_VERIFY CHECKSUM, Compatibility level to 90, remove the […]

4 (1)

2007-09-14

4,510 reads

Overcome BCP limitations for output to CSV file

This is an example to overcome short comings when using BCP to create a 'proper' CSV file. The view vw_Customers_RAW is used in order to provide a method of creating the column heading row and to enclose columns with embedded comma with double quotes, which are not options in BCP. There are more generic methods […]

1 (1)

2006-07-03 (first published: )

2,814 reads

Global System UDF to return ISO Date string

Updated for Permission assignment change 1/11/1006. Ok, I'll bet that you are asking, What is a Global System UDF, right? By Global I mean that the UDF is available from any database on the server. By System I mean that the two part naming rule does not apply to this scalar function. The UDF conversion […]

5 (1)

2006-01-26 (first published: )

414 reads

Create Excel XLS from T-SQL

This is a T-SQL script that uses OLE, ADO, Jet4 ISAM, and Linked Server to create and populate an Excel Workbook (XLS) file from T-SQL query. If the Excel Worksheet exists, the query will append to the "table". The code is designed to be used by SQL Agent and to append to the step output […]

2006-01-18 (first published: )

7,072 reads

Blocked Process script for deadlock correction

This script was created to find an application problem that was causing SQL Server blocked processes. The BlockedProcess table is created to log both the blocker and blocked processes. The sp_BlockedProcess stored procedure is created to handle the situation by: inserting all processes affected by the blocking, notifying the blocking application user, emailing the admins […]

5 (2)

2005-12-01 (first published: )

4,133 reads

Get Column Lists script

This is a script like Column_Gitter by Rick Bolin (RickInMesa), it differs in the fact that it does not use cursors, it optionally adds the table name, it handles UDDT (User Defined Data Types) properly, and handles the new SQL Server 2000 datatypes.Usage: Open this script in QA, Change QA to the desired Database, Edit […]

5 (1)

2003-09-24

702 reads

Restore DB from Disk File script

This script was designed to restore a backup of a production database from disk file, handle multiple DB files, move the files to new location, with new database name that is customized for the date of the backup, create any missing logins, and fix any user accounts that are orphaned by differing SIDs from the […]

2003-04-24

1,040 reads

Blogs

Book Review: High Performance SQL Server (Second Edition)

By

One of the technical books that sit on my work desk (or dining table,...

The PowerShell Basics If Statement–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

T-SQL Tuesday Retrospective #013: What the business wants

By

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...

Read the latest Blogs

Forums

Where To Buy Memo Max Pro Memory Enhancer?

By memoprots

You are positively fortunate that Memo Max Pro happened when you required this the...

How to Display FeatureName of Comptitor First then Npx Feature Name second Based

By ahmed_elbarbary.2010

How to Display Feature Name of Comptitor First then NXP Feature Name second Based...

Load Multiple Excel Files and Worksheets with SSIS

By pramodh kumar tammana

Comments posted to this topic are about the item Load Multiple Excel Files and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers