sql server replication: Invalid column name 'rowguiedcol' - error number 207 -- sql server replication

Invalid column name 'rowguiedcol' - error number 207

Robert A. DiFrancesco
10/29/2004 10:55:38 AM

sql server replication: "The process could not deliver the snapshot to the Subscriber"

I added a new database to the same server as the publisher and distributor.
The error ocurred when pushing a new subscription to it.

I did indicate that the subscriber already has the schema and data.

Any ideas for correcting?

thanks,
bob

Re: Invalid column name 'rowguiedcol' - error number 207

Hilary Cotter
10/29/2004 10:29:55 PM

Sounds like the table you are replicating to has an extra column in it which
is not in the publisher. Look for a column called rowguidcol and delete it.

If you get an error message complaining that this table is published for
replication or a similar message, verify that this table is not published,
or published to.

If it is you might have to do the following:

exec sp_configure N'allow updates', 1
go
reconfigure with override
go

UPDATE syscolumns set colstat = colstat & ~4096 WHERE colstat &4096 <>0
GO
UPDATE sysobjects set replinfo=0
GO

and then issue a sp_MSunmarkreplinfo against the problem table

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]