 | |
Replication errors - vicious circle
microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Replication errors - vicious circle -
01-19-2006
, 07:27 PM
#2
| |||
| |||
|
|
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! |
#3
| |||
| |||
|
|
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! |
#4
| |||
| |||
|
|
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 (AT) discussions (DOT) microsoft.com> wrote in message news:346CE295-5031-45F3-90DA-9CA7A25424A5 (AT) microsoft (DOT) com... 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! |
#5
| |||
| |||
|
|
I receive the error "ad hoc updates to system catalogues are not allowed" from the update command. "Hilary Cotter" wrote: 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 (AT) discussions (DOT) microsoft.com> wrote in message news:346CE295-5031-45F3-90DA-9CA7A25424A5 (AT) microsoft (DOT) com... 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! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.