Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  identify a script that create lock

Author  Topic  Iris Starting Member 2 Posts Posted - 2006-01-06 : 13:39:32 Hi everyone, I am pretty new to SQL script even if i had a drastic learning curve. I can't seem to find out how to identify a script or portion of a script that create a lock. I can identify what lock it is and what step of my DTS package. but i don't know why it does that. So i wish to know is there a diagnostic proceedure I can follow to identify the portion of my script that create the lock. i am sure this is something logical but when knowledge is not acquired yet it kinda hard to figure out. anyway any sugestion oh how to identify the root problem would be appreciated