 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / February 2006Remove Identity column constraint/mgmt
Hello... We have some tables that had been using Identity columns as a Primary Key...but we abandoned that approach a few weeks ago and adopted GUIDs instead. These tables are included in Publications that were originally on SQL 2000...but we upgraded to SQL 2005. Is there a way I can remove the Identity constraint from the server pub...does the Not for Replication handle this? Or...would be better to Drop the column and reinitialize the subscribers? thanks for any help - will You would be best to drop the identity column, NFR will not drop the identity column but will not enforce the identity property if the insert is caused by a replication process.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hello... > [quoted text clipped - 12 lines] > thanks for any help > - will Thanks for the help. I may test out going the NFR route....just so I don't have to mess with the table schema too much. Will changing to NFR force a Re-Init of for the subscribers? > You would be best to drop the identity column, NFR will not drop the > identity column but will not enforce the identity property if the insert is [quoted text clipped - 16 lines] > > thanks for any help > > - will This is something you do on the subscriber - so for transactional replication it will have no impact on reinitialization. For merge and updateable subscribers it will. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Thanks for the help. I may test out going the NFR route....just so I > don't [quoted text clipped - 23 lines] >> > thanks for any help >> > - will |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.