Re: Replication errors - vicious circle
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Thu, 19 Jan 2006 22:01:38 -0500
Issue the following statements
sp_MSunmarkreplinfo 'ProblemTableName'
Then you need to update the colstat column
sp_configure 'allow updates', 1
go
reconfigure with override
go
UPDATE syscolumns
SET colstat = colstat & ~4096
WHERE colstat & 4096 <>0
go
sp_configure 'allow updates', 2
go
reconfigure with override
go
--
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
"TahoePete" <TahoePete@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:346CE295-5031-45F3-90DA-9CA7A25424A5@xxxxxxxxxxxxxxxx
> When I try to create a transactional publication, when I select the table
> I
> want to replicate, I get the error "This table cannot be published because
> it
> does not have a primary key column. Primary key columns are required for
> all
> tables in transactional publications".
>
> Then When I try to make the necessary changes to the table, such as adding
> a
> column for the primary key, I get the error "Unable to modify table.
> Cannot
> drop the table "tablename" because it is being used for replication."
>
> I have never successfully replicated this table or any other. I can find
> no
> evidence of any publications to remove.
>
> I'm stuck!
>
.
- Prev by Date: Re: Replication that causes blocking of process
- Next by Date: Re: Change QueryTimeout
- Previous by thread: Change QueryTimeout
- Next by thread: Replicate to ORACLE
- Index(es):
Relevant Pages
|
