March 8, 2010 at 2:42 pm
but it is set to true (= 1)....
and in the subscription options it is set to true....
now, in looking at the errors previously, I see where it was trying to drop the PK on that table. That is not allowed if I remember right. How would you get around that?? Is that where you would have to use the code to DROP the article, make the change and then add it back in???
March 8, 2010 at 2:54 pm
Yes, you cannot drop PK if table is involved in replication, drop article from publisher make changes and then add back article to publisher, don't forget to re initialize subscriber after changes.
EnjoY!
March 8, 2010 at 3:09 pm
March 8, 2010 at 4:22 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply