Additional Replication Information

SQL Server 6.5 provides the following additional changes to replication:

• The DBREPL.SQL script has been removed.
• The explicit (NOLOCK) optimizer hint is no longer needed in a replication filter; the lock manager has been updated to ignore table locks on the replicated base table during a replication filter.
• NOT FOR REPLICATION can be added to foreign key constraint declarations. For more information, see What's New for Transact-SQL.
• The Replication Topology window includes New Subscriber and Remove Subscriber buttons that you can use to add or remove subscribers. The Replication Topology window also includes graphical images that represent the type of subscriber (SQL Server, Microsoft Access ODBC, generic ODBC, and so on).
• Several of the replication dialog boxes in SQL Enterprise Manager have been enhanced. For more information, run SQL Enterprise Manager and review its replication interface or see the SQL Enterprise Manager online Help.