February 13, 2009 at 11:20 am
I have a 2005 environment, where we have some legacy systems moved that require they be set at compatibility 80 (which I believe is sql server 2000 mode). The TempDB on this install is compatibility 90. Should it be ok to run these in this instance where the compatibility mode of the application db is 80 but the compatibility of tempdb is 90? They seem to work fine, but has anyone experienced any gotchas that revealed themselves after a bit?
Bob
Not a downstroke, fistpicker
February 13, 2009 at 1:13 pm
I have had databases in compatibility mode 80 in SQL Server 2005 without any problems.
February 16, 2009 at 11:49 pm
rmaggio (2/13/2009)
I have a 2005 environment, where we have some legacy systems moved that require they be set at compatibility 80 (which I believe is sql server 2000 mode). The TempDB on this install is compatibility 90. Should it be ok to run these in this instance where the compatibility mode of the application db is 80 but the compatibility of tempdb is 90? They seem to work fine, but has anyone experienced any gotchas that revealed themselves after a bit?
I do ahve few database on cmpt level 80....there isn't any problem related to tempdb
Regards,
[font="Verdana"]Sqlfrenzy[/font]
February 18, 2009 at 7:21 am
Same here, have many in each compatibility mode, no issues. 😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply