Microsoft SQL Server Merge Replication Client Status Information

Below is a select statement which can be placed in a view, for providing information on core merge replication status information usually seen using Microsoft SQL Server Replication Monitor GUI tool. SELECT TOP 1000 [subscriber_server] ,[db_name] ,SubStatus = CASE [status] WHEN 0 THEN ‘Inactive’ WHEN 1 THEN ‘Active’ WHEN 2 THEN ‘Deleted’ ELSE ‘N/A’ END […]

Read More

SQL Server Replication Options

Common configuration notes/options. ============================== Snapshot publication: The Publisher sends a snapshot of the published data to Subscribers at scheduled intervals. Transactional publication: The Publisher streams transactions to the Subscribers after they receive an initial snapshot of the published data. Transactional publication with updatable subscriptions: The Publisher streams transactions to SQL Server Subscribers after they receive […]

Read More