From what I've read, SQL2000 shouldn't lock tables during the initial snapshot for transactional replication, I even checked the option : "Do not lock tables during snapshot generation. All Subscribers must be servers running SQL Server version 7.0 or later." However, running the initial snapshot last night DID lock tables needed by other processes. Am I missing something, or is Microsoft lying ? Help ! I can't be limited to running snapshots on the weekend.