We have a proc that runs
Truncate Table inside an Snapshot transaction. This seems to be causing a
LOCK_M_S lock that blocks the sys view
Is there a convenient work around for this? I like the efficiency of not taking excess logs that happens with truncate, but don't want to lock up my
I'm happy to post the code upon request, but I'm pretty sure this is some behavior of
Truncate being inside a Snapshot transaction. that i'm just unaware of.