You might want to download and use:

Microsoft SQL Server 2008 Upgrade Advisor

Brief Description

Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL...

whitlander

It appears that you will be handling a great deal of date data.

If you have not already found Lynn's posting may I suggest reading this post by...

There are two ways to replace the place holders ... read the following subjects in BOL

RAISERROR and/or FORMATMESSAGE.

It will not be easy and may require a great deal of...

Refer to WayneS post, the "custom" message you receive is because the place holders described in WayneS post are replaced with...

Using BOL for 2000 look at this:

sysmessages

Contains one row for each system error or warning that can be returned by Microsoft® SQL Server™. SQL Server displays the error description on...

If you have extensively followed the moans/groans and complaints associated with some...

1. Assuming your back up is FULL RECOVERY. Perform a complete backup

2. Use Set ROWCOUNT to a resonable size (Start low, watch your log file size, and...

Let me suggest you turn your thinking around.... to the question ... what data do you want out of the DB ... in the form of reports and /or someone...

Again without a Tally table (hence not the most efficient method), but here goes.

CREATE TABLE #tTestData (MyTextCol VARCHAR(max))

INSERT INTO #tTestData( MyTextCol )

VALUES ( 'Without a doubt SQLCentral is home...

For those of you who have not seen RBarryYoung's forume post here:

http://www.sqlservercentral.com/Forums/Topic861691-4-1.aspx?Update=1

Please chime in with your thoughts/comments

Second the motion

Without using a Tally table

DECLARE @What VARCHAR(200)

DECLARE @Start INT

DECLARE @End Int

SET @What = 'Sometimes things may get [SQL GETDATE()] heated[comment:#super hot debate].'

SET @Start = CHARINDEX('[COMMENT',@What,1)

SET @End = CHARINDEX(']',@What,@Start+1)

SELECT @Start,@End

SELECT...

Listen all ye to the voice of the THREAD

http://s0.ilike.com/play#Ella+Fitzgerald:After+You've+Gone:452011:s75875.8175768.13456156.1.2.94%2Cstd_60a18528a0e144b69be14c7363ff75e3

Now this will give you all the statistics, other than those created is Auto_statistics is set ON. Those you should...

Try this for each table in the DB

sp_statistics 'your table name''

Read up on sp_statistics (Books On Line)

Returns a list of all indexes and statistics on a specified table or indexed...