May 9, 2012 at 8:08 am
Hello,
I removed a table from Replication but the table setting is still set as flagged for replication. I am basically changing the structure of the table and need to use sp_rename during the process of converting over. Any suggestions on why the flag is still set? How to change it?
Thanks,
Daniel
May 9, 2012 at 8:18 am
In earlier versions I used to reset the replinfo flag in sysobjects. But there may be a better (i.e. safer) way in 2008. I haven't had to do this for a while so I am going to find out myself.
Check this article out: http://technet.microsoft.com/en-us/library/ms151870.aspx
As I suspected 2008(R2) has better handling for schema changes of published tables.
The probability of survival is inversely proportional to the angle of arrival.
May 9, 2012 at 8:33 am
see my edit.
The probability of survival is inversely proportional to the angle of arrival.
May 9, 2012 at 8:37 am
The table was removed from Replication and it won't be added back. I am still not sure why the flag was not changed.
May 9, 2012 at 1:45 pm
The fix was to basically Add back the Article and than drop it again and it cleared the flag that was on the table.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply