You noted replication in your article about features that need attention. This exactly true. I have used transactional replication for many years, but the limitation that only tables with primary...

This solution would appear to be a sound approach to resolve the locking issue. However, it seems that perhaps a simpler approach would be to move the call to the...