How to reference a Folder as a Drive Letter Chris Skorlinski Microsoft SQL Server Escalation Services While assisting a customer with a SQL 2000 Replication configuration on Windows 2003 we need to reference the \ReplData folder as a Driver Letter. ...

How to run sp_browsereplcmds on a Distribution db backup Chris Skorlinski Microsoft SQL Server Escalation Services From time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing.  When...

REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ PROBLEM : I have a SQL Server 2005 replicating...

Replication: Unable to Synchronize subscribers via Web Synchronization reposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ Problem : The upload message to be sent to Publisher 'XXX' is...

SQL 2005 Merge Agent Blocking in MSmerge_generation_partition_mappings Chris Skorlinski Microsoft SQL Server Escalation Services If you observe blocking in the SQL Server 2005 Merge Agent script out the “nc1MSmerge_generation_partition_mappings” index...

Initial Merge Synchronization not using Bulk Insert Chris Skorlinski Microsoft SQL Server Escalation Services Working with a customer to setup a large subscriber we noticed the Merge Agent was NOT doing a BULK INSERT, but instead was doing row-by-row...