amy26 (4/2/2013)
I'm really bummed about this cause now I can't use some of the new features of SQL 2008 :angry:
Why not?
Comparability level doesn't disable new features, it just changes how the query execution engine handles some constructs and whether some forms of SQL are valid or not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability