Friday, February 24, 2012

can i update GUIDS in sysmergepubliction and sysmergeAricles in sqlserver 2005 ?

Hi fellows ,

there is a senerio where i want to update GUIDS in columns "pubid" and "artid" generate in sysmergepubliction and sysmergeAricles respectivly in sqlserver 2005 ?

2nd is there any easy way to generate scripts of triggers of all replicated tables in subscriber at one .

You should not be updating the GUIDs (pubid and artid) manually in the system tables. Almost all of the replication working is based on these IDs and editing of it is neither recommended nor supported.

You should be able to use the UI to gerenate scripts for all the objects.

No comments:

Post a Comment