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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-24 : 06:04:35
|
| Dear All,i dont know the exact reson why, but i'm guessing the reason for each table had a new guid column is because of transactional replication with update subscribers. actually i dont need this.can i change this to transactional replication? or i need to drop the column in each table? please guide meArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-24 : 06:11:12
|
| Replication will always add a column to the table. This is the way it keeps track of records. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 21:15:29
|
quote:
Originally posted by RickD
Replication will always add a column to the table. This is the way it keeps track of records.
Not true . Extra Guid column will be added only when you do transactional replication with updatable subscription or Queued updating or Merge Replication. This is like trigger which tracks the changes. For one way replication, there is no Guid column being added. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-25 : 02:15:33
|
| sodeep,please let me know how can i drop the column? by using sp_repldropcolumn? or any other way? or can i change the replication type to transactional without deleting the publisher?please let me knowArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-25 : 12:39:44
|
| You can drop column for GUID if you are doing two way transactionalreplication with updatable subscription. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-26 : 01:46:24
|
| i'm not doing two way transactional replication. what ever the updations are there in publisher are going to replicate in subscriber. this is only my requirement. now can i drop the column?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 23:22:28
|
| You have to reset replication first, otherwise sql doesn't let you drop it. |
|
|
|
|
|
|
new column added in subscriber database tables