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 |
|
joseln
Starting Member
11 Posts |
 Posted - 2006-04-10 : 02:30:40
|
| Hi,i have created a DTS Package in which i call a stored procedure. when i execute the package i got an error in the middle as below.(consider the DTS package run 3 hours to complete the execution, the error im getting after 2 hrs of process, meaning i get the work done partially)."Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (Microsoft OLE DB Provider for SQL Server (0):"why is this error happened?. do i need to clear deadlocks for every time i execute DTS package?.then how to clear deadlocks? is there anything to do with SP_LOCKS or SP_WHO before i run DTS?. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-10 : 05:08:10
|
| Deadlocks are something that can alwys happen and you should always cater for them.You can design your system to minimise them but not eliminate them.It is two processes that are both waiting on resources held by the other - they will be stck so sql server kills one.It could be that your design guarantess a deadlock or just that it has caused you to be likely to get them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
deadlock error when execute DTS Package