Replication

Merge replication created w/ DMO - starting snapshot get error
i got it working by just issue a exec sp_start_job for each of the jobs it created. Darin *** Sent via Developersdex http://www.developersdex.com *** ... 30 Jul 2008 15:50

MS SQL 2005 transactional replication: Applying snapshot with an 'after script'
Hello, we want to use the 'after' script functionality after applying the snapshot to the subscriber. Basically we want to put in some triggers, to do some special stuff with that data. The issue is, that although the script is started, we are not able to see whether this script actually ran successful or not.... 30 Jul 2008 13:22

Indexes in msmerge_genhistory table: should one create extra?
Hi All I was going through analysys of missing indexes. I ran some queries from BOL on sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_groups to find out which columns would benefit from index creation. it turned out that MSMerge_genhistory(genstatus included(coldate)) and some other msmerge ta... 7 Aug 2008 08:19

Replication Agent verbose log configuration error
Hi, I am trying to configure verbose log in queue reader agent inSQL 2005. I follow the instructions in BOL (http://technet.microsoft.com/en-us/ library/ms152515.aspx or http://technet.microsoft.com/en-us/library/ms147893.aspx) but I receive an error in parameter Output. Error message says that Outoput parameter... 30 Jul 2008 09:13

Sp_MsMakegeneration deadlock with sp_Msupdategenhistory and sp_MSe
I'm using merge replication on SQL 2005. Replication is relatively new for me. Currently I am investigating on how to stop the deadlocks from happening. I've done a trace on one of the subscribers to get an idea on what is happening. I have 2 publications which run continuous at an interval of 32 seconds. The p... 30 Jul 2008 08:12

subscriber_type = local and Business Logic Handler
Hi there, I tried implementing a custom business logic handler in out replication environment which consists out of a central publisher, three re-publishers and a number of laptops as final subscribers. In the UpdateHandler I check for updates on one table which are not suitable at the time the replication tak... 30 Jul 2008 09:13

issues with triggers in transaction replication
Hi, I am making of sql 2005 - transaction replicaton. data flows from the publisher to the subscriber - staging tables. From the staging tables we want the data to move to the transaction tables at the subscriber end. We are moving the data to the transaction table by having triggers in the staging table... 30 Jul 2008 07:10

merge replication sql 2005 64bit
i was setting up merge replication and received a message that a table couldn't be replicated because it has more than 254 columns. THe table in question has 288 columns. So - I can only replicate 254 columns? Darin *** Sent via Developersdex http://www.developersdex.com *** ... 30 Jul 2008 08:11

Bidirectional Transactional replication
Hi All Do any one know where to get good Knowledge resources for writing and implementing stored procedures for bidirectional transactional replication. I f any body has one implemented recently can you spare the steps involved and the best practises associated with this type of replication. Regards ... 28 Jul 2008 18:14

Bidirectional Transactional replication
Hi All Do any one know where to get good Knowledge resources for writing and implementing stored procedures for bidirectional transactional replication. I f any body has one implemented recently can you spare the steps involved and the best practises associated with this type of replication. Regards ... 30 Jul 2008 08:11