cancel
Showing results for 
Search instead for 
Did you mean: 

pivot

Former Member
0 Kudos

hi

we're working with sql 2008 and 8.8 pl 15.

we get an error when trying to run a query with a pivot function.

"1). [Microsoft][SQL Server Native Client 10.0][SQL Server]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 SET COMPATIBILITY_LEVEL option of ALTER DA 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement (OCTR) (s) could not be prepared."

what can i do to resolve this?

raf

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Raf,

You need to check your database compatibility level. It must be at least SQL Server 2005 or above.

Thanks,

Gordon

Former Member
0 Kudos

Thx Gordon

How do i know what is my database compatibility level right now?

Raf

Former Member
0 Kudos

Go to SQL Management Studio. Check database property.You can find the level.

Answers (0)