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.
| 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 Kizeraka tduggan |
 |
|
|
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 |
|
|
|
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... |
|
|
|
|
|
|
SQL Server 2005 Mode 80 vs. Mode 90