amy26 (4/2/2013)
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.
The trick to get around this type of limitation is to create a separate database - set the compatibility to 100 and run your code from that database using 3-part naming (or synonyms) to reference the tables in the 80 database.
One way of 'tricking' the system to do this is to create a new procedure in the 100 database that has your working code. Rename the old procedure in the 80 database and then create a synonym for the original procedure. The synonym will then reference your new code.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs