If I decide I don't want to use Queued Updating Subscribers, how do I get the replication guid's added off the tables in my database? A restore?
I am testing all my options, and have completed testing the use of queued updating, and want to move on to another option, but the guid's are causing me some problems, and I want to know if there is a sp to get rid of them or do I just need to restore my database?
Thanx!
JLS,
there is no sp to remove these columns. Usually there is no issue as TSQL is
writte using column names rather than columns by position. However, if you
have this sort of statement:
insert into tableX
select * from tableY
Then admittedly there will be issues.
You ask about restoring the database but I'm not too sure which one you are
referring to. If it is the production database and you are using replication
for failover, it would seem to be redundant?
Regards,
Paul Ibison
No comments:
Post a Comment