Microsoft Support of SQL 2000 in Compatability Mode

  • SQL 2000 Extended support seems to have ended. My company is taking on the hosting of an externally hosted application which is SQL 2000 that does not support the DB on any higher release. We will put it on a SQL 2008 R2 instance and keep it in 2000 compatability mode until we can figure out what to do with it. I've been asked if being in compatability mode affects the support dates in any way. I wouldn't think so. What do you think?

  • hayden_jones (4/10/2013)


    SQL 2000 Extended support seems to have ended. My company is taking on the hosting of an externally hosted application which is SQL 2000 that does not support the DB on any higher release. We will put it on a SQL 2008 R2 instance and keep it in 2000 compatability mode until we can figure out what to do with it. I've been asked if being in compatability mode affects the support dates in any way. I wouldn't think so. What do you think?

    Once the database is on a SQL Server 2008 R2 instance it is effectively a SQL Server 2008 R2 database. The compatability mode just ensures that the database engine behaves as it would on SQL Server 2000, such as supporting ANSI-89 style outer joins, etc.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply