|
Posted by bosko19 on 04/13/07 22:01
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?
Thank you!
Bosko
Navigation:
[Reply to this message]
|