Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 SQL Server 2005 Mode 80 vs. Mode 90
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 05/08/2006 :  14:25:07  Show Profile
We migrated our database from 2000 to 2005 not too long ago. The only problem now is converting it from Mode 80 to Mode 90. We have several hundred stored procedures that use *= joins (never should have been used, but its too late to complain now) and it would require a large amount of time to convert them all so that they can run in Mode 90.

I am investigating the merits of using Mode 90 over Mode 80, and need to determine if its even worth the time investment to do so.

So my question is, What differences in terms of performance and functionality are there between SQL Server 2005 Mode 80 and Mode 90?

Any links to articles or forums that discuss this topic would also be appreciated.


Almighty SQL Goddess

38200 Posts

Posted - 05/08/2006 :  15:20:57  Show Profile  Visit tkizer's Homepage
Mode 80 means you are using SQL Server 2000 features and not 2005. So it just depends if you need to use 2005 features. Performance will not change between the two modes just features available.

Tara Kizer
aka tduggan
Go to Top of Page

Constraint Violating Yak Guru

347 Posts

Posted - 05/08/2006 :  16:25:35  Show Profile
>>What differences in terms of performance and functionality are >>there between SQL Server 2005 Mode 80 and Mode 90?

Edited by - cshah1 on 05/08/2006 16:26:44
Go to Top of Page

Yak Posting Veteran

71 Posts

Posted - 05/22/2006 :  12:26:19  Show Profile  Visit samuelclay's Homepage
hmm, Were you able to use the Database Diagrams while in mode 80?
I migrated several dbs from 2000 to 2005 and the only way I could get the diagrams to work was by changing the compatibility level to 90.

If anyone found a way around this, I would like to know how they did so...

Edited by - samuelclay on 05/22/2006 12:27:00
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000