Lowry Kozlowski (4/1/2011)
We didn't want to break anything, and once you change the compatiblity you cannot go back.
The compatibility level can be changed back, if needed. When you change this, there is nothing in the database that is upgraded or converted that will prevent you from changing it back.
All this does it tell SQL Server what commands, functions, etc... are available in that database.
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