Data Engineering – Learn from the experts
-
Transactional Replication – Configuring Distributor
Lets Discuss the steps to Configure Distributor in detail. In this article I am using the Server SansuTest as the Distributor. The Distributor is configured from SSMS as follows :
-
Replication Components and Agents
Replication Components SQL 2005 replication is based on the Publish and Subscribe metaphor. Let us look at each of the individual components in detail.
-
Check Identity
This will list out identity columns in a Database. This is compatible to SQL 2005 only.
-
Connection Property
This script will list out the current connections on SQL 2005
Got any recommendations?