troubleshooting Question

MSSQL 2000 Server vs. MSSQL 2005 Compatibility Mode

Avatar of mrlevesque
mrlevesque asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
2 Comments1 Solution1536 ViewsLast Modified:
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.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros