Field size too large - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Field size too large

Author

Topic

roel_vz
Starting Member

16 Posts

Posted - 2008-05-09 : 09:56:04

I have set up transaction replication between two databases. Data from a table in the first database is replicated to the same table in another database.

The table at the publisher already has some data in it. The table at the subscriber is empty. When the replication is synchronizing, I get the following errors in the replication monitor:
*The process could not bulk copy into table "dbo"."virtualdatalocations_waitingqueues". (Source: MSSQL_REPL, Error number: MSSQL_REPL20037) Get help: http://help/MSSQL_REPL20037
*Field size too large

The table looks like this:
CREATE TABLE virtualdatalocations_waitingqueues (
dataid int ,
personid int ,
queueid int ,
CONSTRAINT FK_vw_dataid
FOREIGN KEY(dataid) REFERENCES datalocations(id) ON DELETE CASCADE ,
CONSTRAINT FK_vw_personid
FOREIGN KEY(personid) REFERENCES persons(id),
CONSTRAINT FK_vw_queueid
FOREIGN KEY(queueid)REFERENCES waitingqueues(id)
);

It used to run fine in the past. I couldn't find any help on google or on forums.

Any help or comments are greatly appreciated.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-09 : 11:34:47

Is structure(schema) same in both table?