Any issue using tempdb at SQL Server Compatabilty 90 when some db's are set to 80?

  • 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

  • I have had databases in compatibility mode 80 in SQL Server 2005 without any problems.

  • 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]

  • 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