Compatibility level sql server (Solved)
Incorrect syntax near ‘PIVOT’. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
The reason you see this error when upgrading from SQL Server 2000 to SQL Server 2005 (or 2008), SQL Server 2000 does not support Pivot function so you need to update COMPATIBILITY_LEVEL to run this function.
For SQL Server 2005
EXEC sp_dbcmptlevel 'your_database', 90
For SQL Server 2008
EXEC sp_dbcmptlevel 'your_database', 100
Tags: Incorrect syntax near PIVOT You may need to set the compatibility level of the current database to a higher value to enable this feature See help for the stored procedure sp_dbcmptlevel, compatibility level sql server, you may need to set the compatibility level of the current database to a higher value, incorrect syntax near \pivot\ you may need to set the compatibility level of the current database to a higher value to enable this feature see help for the stored procedure sp_dbcmptlevel, c# compatibility level sql server, set the compatibility level of the current database to a higher value sp_dbcmptlevel, set the compatibility level of the current database to a higher value to enable this feature see help for the stored procedure sp_dbcmptlevel, sql server pivot compatability, sql server pivot compatibility level, sql server you may need to set the compatibility level of the current database to a higher value to enable this feature
Related posts:
- Not associated with a trusted sql server connection (Solved)
- Download Microsoft SQL Server 2005 Express Edition
- Download Microsoft SQL Server 2008 Express Edition
No Comments