GilaMonster (4/2/2013)
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.
Well, for example... I wrote a stored procedure that uses PIVOT and I cannot run this procedure when the compatibility mode is set to 80. It will only work if its set to 100.