Lock Timeout in Replication Create Publication

Normally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber.  However, the create Publication was being blocked on the Publisher.  We discovered a database trigger used to AUDIT all schema modification on the Publisher was root
Read More »