Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transfer SQL Objects using DTS: Do tables lock?
Message
 
To
21/02/2005 11:10:00
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00988870
Message ID:
00990260
Views:
23
There is no special locking placed by DTS. The locking is done based on servers isolation levels.

>Hello,
>
>I have created an SQL DTS package that transfers objects and data from one database to another.
>
>
>Does this process lock the source tables?
- Jayesh
Previous
Reply
Map
View

Click here to load this message in the networking platform