FIX: Merge Snapshot Generation Fails with Error Message: " Line 326: Incorrect Syntax near '-' if the Table Schema Contains a ROWGUID Column (299439)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q299439 BUG #: 353192(SHILOH_BUGS) SYMPTOMS If a table that is being merge published has a ROWGUID
column, and the ROWGUID field is not the last column in the table, the initial
snapshot generation for a merge publication may fail and the following errors
are logged in the snapshot output file: ***
[Publication:'snapshotfailtest'] Make generation time: 691 (ms) ***
SourceTypeId = 5 SourceName = SERVER1\NAMED1 ErrorCode = 50007
ErrorText = Line 326: Incorrect syntax near '-'. Line 326: Incorrect
syntax near '-'. Repl Agent Status: 6 Disconnecting from Publisher
'SERVER1\NAMED1'
CAUSE This problem occurs if:
- The ROWGUID column is not the last column defined in the
table schema.
-or- - The column name for the ROWGUID column contains an
underscore "_" character.
RESOLUTIONTo resolve this problem, obtain the latest
service pack for SQL Server 2000. For additional information, click the
following article number to view the article in the Microsoft Knowledge Base: 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND To work around this problem either:
- Drop, and then re-create the table so that the ROWGUID
column is the last column in the table definition.
-or- - Rename the column name for the ROWGUID column and remove
the underscore "_".
STATUSMicrosoft has confirmed that this is a
problem in SQL Server 2000.
This problem was first corrected in SQL Server 2000
Service Pack 1.
Modification Type: | Major | Last Reviewed: | 4/6/2004 |
---|
Keywords: | kbBug kbfix kbSQLServ2000sp1fix KB299439 |
---|
|