Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cronid
Starting Member
26 Posts |
 Posted - 2006-08-31 : 13:28:28
|
| I have 9 tables that I am replicating. Two tables do not replicate. For those two, columns originally defined as integer are now seen as char (I'm seing that the data only contains NULLS and zeros). When I try to redefine the column I get a message 'unable to modify a table used for replication'.Is there a quick fix for this? |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-02 : 04:25:13
|
| Under the Replicated Database goto "sysobjects" table and find the row for that particular table/tables and change the "replinfo" Column value to "0".ThanksRishi Maini |
 |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-02 : 04:26:36
|
| Furthermore when you say "Two tables do not replicate" I assume that these two tables are not part of Publication ..Right ?ThanksRishi Maini |
|
|
|
|
|
|
Changing table definition after defining merge rep