What are the challenges you face when working across database platforms? Take the survey
Options

Create Snapshot - Incorrect syntax near 'COLLATE'.

EHSUserEHSUser Posts: 9
edited October 24, 2006 12:23PM in SQL Compare Previous Versions
I am having a problem with one of my database servers.
When I create a snapshot on this database I get this error:
It is an MSSQL 2005 server.
Reading permissions
Incorrect syntax near 'COLLATE'. 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.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'ELSE'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'ELSE'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'WHEN'.
Incorrect syntax near the keyword 'ELSE'.

Comments

Sign In or Register to comment.