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
 SQL Server Development (2000)
 SQLDMO Deadlocking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-12-21 : 18:28:01
Ashton writes "I am getting the following exception when I try to generate DDL script for a procedure using the SQLDMO library:

[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 120) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SQLDMO.StoredProcedures.Item(Object Index, Object Owner)

What would cause a call to SQLDMO in this case, looking like it's getting an item from the procedures collection to deadlock?

Thanks,

Ashton"
   

- Advertisement -