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 you please let me know what we have to do to resolve this issue?
Thank you!
Bosko
Is this been like this since the invocation of Database mirroring on these instances?
If not see what has been changed since the last successful occurence.
|||The problems started upon implementation of the database mirroring|||I'm also facing the same issue.
Did anyone find a solution or workaround?
|||I posted this in a couple different forums/newsgroups and never got an answer. We are still having this problem.
Bosko
No comments:
Post a Comment