About Us   SSWUG Articles   Articles   FAQ   Administration   Backup/Restore   Connectivity   Development   General   Installation   Replication   Transfer/move   Trouble   SQL 6.5   Scripts   Tips   Test Exams   Advertise   Download   History   Search   Traffic   Related Links         Add to Favorites

What SQL Server editions support replication? Answer: SQL Server 2000 comes in six editions: Enterprise Standard Personal Developer Desktop Engine SQL Server CE and supports the following replication types: Snapshot Transactional Merge This table shows what replication types are supported by the editions of SQL Server 2000: Editions Snapshot Transactional Merge Enterprise Yes Yes Yes Standard Yes Yes Yes Personal Yes Subscriber only Yes Developer Yes Yes Yes Desktop Engine Yes Subscriber only Yes SQL Server CE No No Anonymous Subscriber only SQL Server 7.0 comes in six editions: Enterprise Standard Desktop and supports the following replication types: Snapshot Transactional Merge This table shows what replication types are supported by the editions of SQL Server 7.0: Editions Snapshot Transactional Merge Enterprise Yes Yes Yes Standard Yes Yes Yes Desktop Yes Subscriber only Yes

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators. (c) 1997, 2005 Bits on the Wire, Inc