On my example...that was the only one enabled...

Glad it is working.

So it worked?

Laura_SqlNovice (7/26/2012)

---

Leeland I get this error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TEST2".

OLE DB provider "MSDASQL" for linked server "TEST2" returned message "[Microsoft][ODBC...

Sorry for the confusion...

In my example I configured both the 32 bit and x64 ODBC

the 32 bit ODBC.exe is located in that path I listed above C:\windows\System32 directory.

right click on...

I have successfully created a linked server from SQL 2012 to a SQL 2000 server.

It isn't supported to the best of my knowledge but it has been working so far.

The...

Thanks for this post and thanks Gail for your replies...I ran into this issue today on a SQL 2000 to SQL 2008 R2 upgrade...based on your comments I was able...

opc.three (7/17/2012)

---

I like that you set the DB to SIMPLE recovery before rebuilding indexes but I am wondering why you are freeing proc cache and dropping clean buffers? If you're...

In the past I have used a script like the one below to upgrade from sql 2000 to sql xxxx...

SET NOCOUNT ON

USE master

--------------------------------------------------------------------------------------------------

-- </YOUR DATABASE INFO/> RESTORE Process Started On...

Is there an update? Was the second script more successful?

Hi DK,

The script that is posted in the first couple of replies has been changed by me and I have attached the updated script along with another script that you...

rick.gotner (3/9/2012)

---

Just a thought, since you are getting degraded performance in a query that executes using parrallelism on a new server install. Have you checked the max degee of...

Lynn Pettis (3/8/2012)

---

I provided SQL Server support to a PeopleSoft development/support staff for 5 years. The PeopleSoft...

Good Eye!

During the upgrade I took the SQL 2000 database, restored it to the 2008 server, let it restore and upgrade.

Once complete I ran the following steps...

EXEC dbo.sp_dbcmptlevel @dbname = N'xxx',...

Kind of a side question...can someone give me a brief explination on how to determine what columns go into the index vs. the INCLUDE?

For instance, I created the exact index...