|
|
Posted by bosko19 on 04/16/07 04:29
On Apr 13, 6:45 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (bosk...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
LOL...I didn't think it looked good either :)
The database server has a dash in it (i.e. CompanyName-SQL1 and SQL2
respecitvely). All databases are just alpha characters except for one
that begins with a number sequence (i.e. 1000DatabaseName).
Thank you in advance!
Bosko
Navigation:
[Reply to this message]
|