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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-25 : 08:13:42
|
| Lindsay writes "SQL Server 7.0 - 7.00.1028Windows NT 4.0We have a DTS that is called from a batch file (that is scheduled in a job that kicks off every nite) that has just started to fail. This DTS deletes all rows from a table and imports new data from a text file. I see under Current Activity, Locks/Objects several locks listed for the index on this table. My question is how can I get rid of the locks? I right-click on them and the option to kill them is greyed out. The DTS has failed three days in a row now, and we have not made any changes to it since it was created four years ago. Any help would be appreciated. Thanks!" |
|
|
|
|
|
Failed DTS - because of locks