enrique_aeo
asked on
ALTER DATABASE Sales SET COMPATIBILITY_LEVEL = 100;
Hi experts
I could describe any scenario where you use this code:
ALTER DATABASE Sales SET COMPATIBILITY_LEVEL = 100;
I could describe any scenario where you use this code:
ALTER DATABASE Sales SET COMPATIBILITY_LEVEL = 100;
what exactly are you asking?
ASKER
when I use this command? what is it good for? can share some real scenario?
SET COMPATIBILITY_LEVEL
SET COMPATIBILITY_LEVEL
Hi,
It is to downgrade the compatibility level of current Sql database to
SQL Server 2008 and SQL Server 2008 R2
It is to downgrade the compatibility level of current Sql database to
SQL Server 2008 and SQL Server 2008 R2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can a T-SQL statement does not work if I do change compatibility
ASKER
please
an example: SQL 2014 introduced changes to the cardinality estimator
an example: SQL 2014 introduced changes to the cardinality estimator
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Agreed.
Do you have any example where T-sql where some have stopped working to change the compatibility level?
Do you have any example where T-sql where some have stopped working to change the compatibility level?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.