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 |
|
joni
Yak Posting Veteran
50 Posts |
 Posted - 2007-10-24 : 07:31:40
|
| Hi Gurus,I would like to know if I put the Compatibility Level in a SQL Server 2005 installation to 70 I can make afirmation that I have a full SQL Server 7.0. If the answer is "Yes" where I can find a documentation or a FAQ that explained this topic. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-24 : 07:52:52
|
| Why do you want to do that? There is no guarantee that SQL 2005 will behave identically with SQL 7, so you would still need to perform tests / acceptance.All it will do, to my way of thinking, is prevent you using SQL 2000 / SQL 2005 specific features, and thus your code will be safe to deploy on a SQL 7 system (but, again, identical behviour is not guaranteed, so you would need to re-test under SQL 7)Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-24 : 08:07:30
|
quote:
Originally posted by joni
Hi Gurus,I would like to know if I put the Compatibility Level in a SQL Server 2005 installation to 70 I can make afirmation that I have a full SQL Server 7.0. If the answer is "Yes" where I can find a documentation or a FAQ that explained this topic.
Note that then all the functions referred in the queries related to 2005 would result in errorMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Compatibility Level