Home > Archive > MS SQL Server Replication > July 2005 > Blocked table









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Blocked table
Lina Manjarres

2005-07-29, 8:24 pm

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?

Thanks a lot!
Hilary Cotter

2005-07-30, 7:23 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
"Lina Manjarres" < LinaManjarres@discus
sions.microsoft.com> wrote in message
news:6D8D5772-3C47-485B-A96B- 997BA437C2D2@microso
ft.com...
> 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?
>
> Thanks a lot!



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com