José Moreira Neto | SQL Server Escalation Services Automatic Identity Range Management Microsoft SQL Server automatically generates sequential numbers for new rows inserted in the table containing the identity column. Identity columns are normally included as part of Primary Keys, therefore the need to avoid duplicates. To use identity columns in a replication topology that
Read More »
Rishi Maini | Microsoft SQL Escalation Services This blog posting discusses the new Distribution Agent SubscriptionStreams parameter. This option reduces the latency when moving data from Distributor to Subscriber by using multiple parallel writer threads. For more information on Replication “threads” see Transactional Replication Conversations blog posting. From SQL Books Online (good place to start)
Read More »
Rishi Maini | Microsoft SQL Server Escalation Services All about “Not for Replication” “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. Feature used when the DBA would like the transactions to behave differently when
Read More »
Anurag Sharma | Microsoft SQL Server Escalation Services Log Reader fails with below error message The process could not execute ‘sp_repldone/sp_replcounters’ on ‘SQLGUY’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 The log scan number (23:49:3) passed to log scan in database ‘PUBLISHER’ is not valid. This error may indicate data corruption or that the
Read More »
Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008. You can view this video from the BLOG or double-click to open in YouTube. He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes
Read More »