all groups > sql server replication > july 2005 >
You're in the

sql server replication

group:

Blocked table


Blocked table Lina Manjarres
7/29/2005 12:52:02 PM
sql server replication:
I have a merge sinchronization working just fine. And I have a table
sinchronizing a long time ago without data because i was not using it yet.

No that I have decided to use it, it always said that I can't insert Null in
the rouguid column.

How can I fix it?

Re: Blocked table Hilary Cotter
7/30/2005 6:20:10 AM
EXEC sp_configure 'allow',1
go
reconfigure with override
go
use DataBaseName
go
update sysobjects set replinfo = 0 where name = 'TableName'
go
EXEC sp_configure 'allow',0
go
reconfigure with override
go
sp_MSunmarkreplinfo 'TableName'
go

Then issue the following

alter tablename
drop column rowguid

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

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button