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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2007-06-10 : 20:08:54
|
| Hello,Does anyone know of a document that summarizes the differences in SQL for both sql 2000 and 2005?My goal is the write script that is compatible with both (i'm currently using sql2K but I want it to be usuable in sql2005.) |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-10 : 21:35:33
|
| If you check Books On Line there's a Whats new in 2005 section that highlights the new addtions in 2005.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-10 : 23:08:23
|
| Don't query system table directly, sql2k5 uses views with differnt name instead. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 03:53:04
|
| I've put some bits and pieces that I have found here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80138and will add to it as I discover new things. We found so little that needing fixing we aren't putting too much effort into supporting both, we are developing against SQL 2000 and then doing a QA test on SQL 2005.Of course that prevents us taking advantage of new SQL 2005 features, but we need all clients to upgrade firstKristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-11 : 08:54:51
|
| <<My goal is the write script that is compatible with both (i'm currently using sql2K but I want it to be usuable in sql2005.)>>Then code in sql server 2000 which is by default run in 2005 as wellMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Writing script for both sql 2000 and 2005