question

hodkinss avatar image
hodkinss asked

Backups of SQL 2000 restored as SQL 2005

When a backup of a SQL 2000 database is restored as a SQL 2005 database it normally comes up with a property compatibility level of 80. If a script was applied to this using SQL 2005 TQL, would it still parse?

We have a supplier who repeatedly sends scripts written in SQL 2005 not SQL 2000 which is the database version. I am trying to find any reasonable explanantion as to why they should do this on so many occasions

sql-server-2005sql-server-2000backupscript
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

Why they do it is simple: they have poor quality control. It also ought to make you think that you could move this db into SQL 2005 mode without issues.

If I set one of my test SS2K8 databases to 80 mode, it still compiles and executes 2005/2008 based scripts with CTEs. My guess is that it is forward compatible.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.