Avatar of mrlevesque
mrlevesque asked on

MSSQL 2000 Server vs. MSSQL 2005 Compatibility Mode

Greetings,
Can anyone explain to me the difference between running a database on a SQL 200 server vs running the same database on a SQL 2005 server in SQL 2000 (80) mode.
We are trying to move our various databases on to a single, high powered SQL 2005 Cluster. Some of the older servers are running SQL2000. I would think that I could move a SQL 2000 database to the new cluster and run it in compatibilty mode, but I am getting resistance from a few vendors.

Thanks
Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
MohammedU

8/22/2022 - Mon
matrix_aash

It easy to configure it. Right click the database and change the compatibilty to Sql Server 2000.
 Lot of people run it like this. I dont think there is any problem in doing so.

Cheers.
ASKER CERTIFIED SOLUTION
MohammedU

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61