Category: ReplTalk Blog

ReplTip Push v Pull Subscriptions

Share this PostHere is a quick ReplTip on difference in SQL Management Studio and Replication Monitor for Push v. Pull Subscriptions. Push v. Pull with Management Studio For PULL subscribers you must connect via SSMS or Remote Desktop (RDP) connection to the Subscriber to performance administrative tasks like starting, stopping, or changing parameters. The icon
Read More »

MSrepl_agent_jobs does not exists

Share this PostProblem Setting up Transactional Replication in an AlwaysOn Availability Group environment and getting error similar to one shown below: Msg 14262, Level 16, State 1, Procedure sp_MSrepl_track_addjob, Line 57 [Batch Start Line 12] The specified table (‘MSrepl_agent_jobs’) does not exist. MSrepl_agent_jobs is a new table added to Distribution database in SQL 2017 CU6
Read More »

The insert failed. It conflicted with an identity range check constraint

Share this PostTaiyeb Zakir Microsoft SQL Server Escalation Support Services When replicating identity columns https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-identity-columns  and using Auto Identity management, you need to make sure ranges are defined properly. The default “ranges” for automatic identity range management, while good 20 years ago, may need to be tuned for today’s higher workloads. Share this Post