Compatibility level history

• Tim Ermlich

  SSC-Addicted

  Points: 429

  More actions

  May 3, 2007 at 12:54 pm

  #116583

  I have a SS 2005 server that I have restored 2000 backups to. They restore with 80 compatibility. I have since changed to 90 on all DB's, but wanted to determine the dates that I switched compatibility for each DB. I've looked in master.dbo.sysdatabases/sys.databases but it has only 1 row for each DB.

  Is there a way to determine when the compatibility level was switched?

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  May 3, 2007 at 4:40 pm

  #704238

  I very much doubt there is a way to determine this. 

  ---------------------------------------
  elsasoft.org