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,508 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,787 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: )

411 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: )

6,883 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,127 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

701 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,027 reads

Blogs

Captioning Options for Your Online Conference

By

Many conferences have moved online this year due to the pandemic, and many attendees...

Virtual Log Files

By

Today’s post is a guest article from a friend of Dallas DBAs, writer, and...

Power BI – Hungry Median

By

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...

Read the latest Blogs

Forums

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Sql Server Specs Question

By smattiko83

Hi, I have two different servers that I do a bulk insert on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers