Average 28000 requests/month











  General Replication Information - SQL Server 2005
  Post sp2 Builds - fixes and cumulative updates
  Setting Up Transactional Replication with SQL Server 2005
  How to manually remove a replication in SQL Server 2000 or in SQL Server 2005
  SQL Server Replication Crib Sheet
  Peer-To-Peer vs. Bi-Directional Transactional Replication
  Merge non-convergence article by Lizet Pena de Sola: 1, 2
  Merge bug for DDL researched by Mike Hotek
  Merge Replication Performance Improvements in SQL Server 2005
  Microsoft Replication-Based Knowledgebase Articles - SQL Server 2005
PRB: Subqueries that you define on merge articles are not re-evaluated
  The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters when you synchronize a merge subscription in SQL Server 2005
  General Replication Information - Mostly SQL Server 2000
MSDN on replication
SqlServerCentral - articles on most aspects of replication 
Alexander Chigrik's articles on setting up replication
Narayana Vyas Kondreddi's site - inc especially useful SQL 7.0 tips and some good scripts
MVP Optimisations for replication
Michael Hotek's site - inc good metadata purging article
Text Replication - Article on Google Groups
Support WebCast: Microsoft SQL Server 2000 Transactional Replication: Queued Updating Subscription
Microsoft Team Article: Queued Updating Subscriptions, inc Unreadable Queued Commands
Microsoft Support
Version Compatibility
Merge Replication Performance Tuning and Optimization
Transactional Replication Performance Tuning and Optimization
Replicating to schemas having different tables
  How to break replication
Programatically starting agents
  Microsoft Replication-Based Knowledgebase Articles - SQL Server 2000
  INF: How to Troubleshoot SQL Server Merge Replication Problems
  PRB: IIS Lock Down Tool May Break RDA or Replication That Uses Anonymous Authentication
  How to manually remove a replication in SQL Server 2000
  Replication setup is not successful when SQL Server 2000 is deployed by using a disk image
  Merge replication results are incorrect or merge replication fails when you try to use merge replication to merge SQL Server 2005 Mobile Edition data with SQL Server 2000 data
The -skipperrors Distribution Agent parameter for SQL Server 2000 may skip more commands than expected
INF: Understanding Merge Replication Article Processing Order
INF: How to Troubleshoot SQL Server Merge Replication Problems
INF: Understanding Merge Replication Conflict Detection and Resolution
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
INF: Troubleshooting Linked Server Error 7391
Potential causes of the "SQL Server does not exist or access denied" error message
How to troubleshoot network connectivity
HOW TO: Set Up Alternate Synchronization Partner in SQL Server 2000 Merge Replication
HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet and TechNet instructions on Proxy server settings
HOW TO: Enable Replication Agents for Logging to Output Files in SQL Server
HOW TO: Program the SQL Merge Control by Using Visual Basic .NET
HOW TO: Automate Replication over a Dial-Up Connection
HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000)
HOW TO: Implement Bidirectional Transactional Replication (also this walkthrough).
HOW TO: Manually Synchronize Replication Subscriptions by Using Backup or Restore
Step by Step: Program Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework
FIX: sp_scriptpublicationcustomprocs Generates Replication Stored Procedures
  PRB: sp_attach_db and CREATE DATABASE FOR ATTACH Do Not Remove Replication Tables
  PRB: Custom Stored Procedure Resolvers Don't Fire When Conflict Involves UPDATE and DELETE
  PRB: Non-Convergence When SQL Server Processes Child and Parent Generations in Separate Generation Batches
  PRB: Bulk Operations into Tables Result in Rows Not Replicated in Merge Replication
  PRB: Automatic Identity Range Handling Is Not Correct If the Merge Agent Runs an Insert Trigger
PRB: You Cannot Create a Replication Publication If an Article Name Contains a Special Character

PRB: Changes to a Table That Is Part of an "Immediate Updating" Subscription Generates an Error Message

PRB: Adding a Linked Server Causes Error 15028

PRB: Error 4928 Occurs When You Try to Rename a Non-Replicated Column
PRB: Expired Subscription Cleanup Agent Fails if the First Published Database is Deleted
PRB: You Receive Error Message: "Failed to enumerate changes in the filtered articles" When the SQL Server Merge Agent Fails
  SQL Discussion Sites
SQLServerCentral - dedicated replication section, but you must register
Microsoft Newsgroup - SQL replication section
  3rd-Party Tools
Imceda Fast backups which occupy little space
Lumigent Analyse the transaction log
Red-Gate Compare databases easily - schema and/or data
VMWare virtual operating systems - ideal if you are a beta tester of SQL Server 2005
XPSMTP great alternative to xp_sendmail when MAPI isn't a choice
  Other Useful SQL Sites
Nigel Rivett's SQL Scripts site
UK SQL Server Users Group - Tony Rogerson's site
Online SQL Server magazine
SQL Team
  SQL Server Performance
  Professional Organisation for SQL Server
 
Tibor Karaszis Site
SQL Security Tools
SQLDTS
SQLIS (DTS for the 2005 era)
MVP site

April 2006