基表上不需要额外的锁,因为复制只分析日志文件,而不是分析基表。
No extra locking is required on the base tables as replication only analyzes the log files and not the base tables.
确信服务器有足够的锁资源数,用以修改相关的删除表和复制表。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
大容量更新锁:在向表进行大容量数据复制且指定了TABLOCK提示时使用。
Bulk Update Locks: Used when bulk-copying data into a table and the TABLOCK hint is specified.
应用推荐