Dynamics SL 7 Compatibilty Level issuse

[Ed Dror]

Hi there,

We are using Dynamics SL 7.0, SQL Server 2005, Windows 2003 R2 server
I try to create Pivot query and I got error says:
Msg 325, Level 15, State 1, Line 6

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.

I checked and the current compatibility level is 2000 (80)

I look at article ID 922650
Q6. Can Microsoft Dynamics SL databases run with a compatibility level of
SQL Server 2005 (90)?
A6. No, Microsoft Dynamics SL databases should remain set with a
compatibility level of SQL Server 2000 (80). The SQL Server 2005 (90)
compatibility level is known to cause problems in Microsoft Dynamics SL 6.5
SP1 and in Microsoft Dynamics SL 6.5.

But this is 6.5 what abount SL 7.0 ?

Can I changed the compatibility level to 2005 (90)

Thanks,
Ed Dror

[Dave Ireland]

wrong newsgroup, Ed - this is for Dynamics CRM.

"Ed Dror" <ed....@bluepoint.com> wrote in message
news:EE102A30-2E1F-4303...@microsoft.com...