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

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 SQL Server 2005 Mode 80 vs. Mode 90

Author  Topic 

xenoak47
Starting Member

3 Posts

Posted - 2006-05-08 : 14:25:07
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.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-08 : 15:20:57
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

cshah1
Constraint Violating Yak Guru

347 Posts

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

http://msdn2.microsoft.com/en-US/library/ms178653(SQL.90).aspx
Go to Top of Page

samuelclay
Yak Posting Veteran

71 Posts

Posted - 2006-05-22 : 12:26:19
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...
Go to Top of Page
   

- Advertisement -