Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    2

    Question Unanswered: Sql 2008 and compatibility level 80

    Is there any technical reason why an application certified on sql 2000 should not work properly on sql 2k8 with cmpty level 80? In other words would there be any possible data or functionality losses in attaching a 2000 db to a 2008 server and keeping the 80 level?
    Thank you

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There is nothing directly connected with database compatibility level, but there could be potential problems due to the stricter security that is standard in SQL 2008 compared to the relatively trusting assumptions of SQL 2000. In other words, you won't lose any functionality when you move from SQL 2000 to SQL 2008, but you could still have applications that use unsecure features of SQL 2000 come to a screeching halt when that application encouters the default security of SQL 2008.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    As well as comments already raised, particuarly BUILTIN\Admin, you can look at the Upgrade Advisor.
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •