Posted by Erland Sommarskog on 04/13/07 22:45

(bosko19@gmail.com) writes:
> We have recently set up two SQL Server 2005 Standard Edition servers
> with database mirroring. The mirrors function and fail over without a
> problem, but the Database Mirroring Monitor Job fails every time with
> the following error message:
>
> Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Incorrect
> syntax near the keyword 'with'. If this statement is a common table
> expression or an xmlnamespaces clause, the previous statement must be
> terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step
> failed.
>
> Both SQL Servers are running SP2 with the latest patches.
>
> Can anyone help with the resolutionto this this issue?

Eh, that looks bad. I haven't worked much with mirroring, or more precisely
not at all. But a syntax errors is not what I would expect. Could you
list the exact name of the servers and databases involved? My suspicion
is that there is a problem with special characters.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]