SQL Server – Undocumented – Function Calls / Day 01

Background Profiling our database system and noticed a call to sp_MSreset_synctran_bit. Wanted to review a bit. sp_MSreset_synctran_bit Code Dissect EXEC %%Object(MultiName = @qualified_name).LockMatchID(ID = @tabid, Exclusive = 1, BindInternal = 0) A Lock semaphore/mutex passes along the Object ID EXEC %%Relation(ID = @tabid).SetSyncTranSubscribe(Value = 0) Set Sync Transaction Subscriber Reset value to 0 Likely means … Continue reading SQL Server – Undocumented – Function Calls / Day 01