Microsoft KB Archive/248624

= FIX: Creating Publication Fails if Table Has Long Column Name =

Article ID: 248624

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q248624



BUG #: 56747 (SQLBUG_70)



SYMPTOMS
When creating a publication for replication, the publication creation process may fail with the following errors:

Server: Msg 50007, Level 16, State 1, Line 0

Line 12: Incorrect syntax near '='.

Server: Msg 50007, Level 16, State 1, Line 0

xp_execresultset: unable to execute result set

Server: Msg 208, Level 16, State 11, Line 1

Invalid object name 'dbo.sp_MSsync_upd_t1_1'.



CAUSE
This may occur if both of the following conditions are true:
 * One of the columns included in the publication has a name that is longer than 40 characters.

-and-
 * You are attempting to create a transactional publication with the Allow Immediate-Updating Subscribers option.

To work around this problem, either reduce the length of the name of the column that is longer than 40 characters or create the publication without immediate-updating subscribers.



WORKAROUND
To work around this problem, either reduce the length of the name of the column that is longer than 40 characters or create the publication without immediate-updating subscribers.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.



Steps to Reproduce the Problem
  Use the following statement to create a table that has a column with a name greater than 40 characters long: CREATE TABLE [dbo].[t1] ( [this_will_fail_because_the_column_length_is_greater_than_forty] [int] NULL, [j] [int] NOT NULL primary key, [msrepl_synctran_ts] [timestamp] NOT NULL )  Try to create a Transactional publication and allow immediate updating subscribers.

Additional query words: replication repl

Keywords: kbbug kbfix KB248624

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.