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 |
|
sujey
Starting Member
1 Post |
 Posted - 2010-11-25 : 09:54:43
|
Can You help me please:
running a job under sql server 2000 get the following error:
Transaction (Process ID 235) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-25 : 09:58:48
|
Do you know what a deadlock is?
Two processes are each waiting on resources held by the other
It's deadlocking with another process and the system has killed it rather than hanging.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Error SQLSTATE 40001