SQL Server Replication (SSQA.net)

Replication FAQ - how to know Distributor and Publisher with scripts

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are Read More...

Transactional Replication Snapshot Issues - useful resources to resolve

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process. Read More...

SQL Server Replication - presentation from Scottish Area SQL Server User Group

As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication, Read More...

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as Read More...

How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION Read More...