Create Snapshot - Incorrect syntax near 'COLLATE'.

EHSUser

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'.

Chris Auckland

What version of SQL compare are you using?

Older versions of SQL compare can have issues if the database has a SQL Server 7 compatability level.