Deadlocks when running select query

[AtomicWedgie]

Help,

could anybody tell me why the following message is being generated?

Server: Msg 1205, Level 13, State 61, Line 9
Transaction (Process ID 57) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


Thnx in advance

Atomic Wedgie

 

[hmckillop]

Would need more information, like where are you running the query from, what else is running on the server, what is the transaction isolation level (i.e. have you explicitly set it somewhere, is the query being run from DTC or Query Analyser).

Have you tried using enterprise manager, or sp_who (sp_who2) and sp_lock to see what locks are being held.

Sorry cant be of more help without having more info.

 

[AtomicWedgie]

I am running the query from Query analyser on my local desktop. The database is on a server dedicated for that DB.

I know now that somebody opened a table via enterprise manager directly on the database/server that i was also querying on.

Regards,

Atomic Wedgie

 

[leangross]

Need help!!!

I'm experiencing the same problem. I'm using a visual basic in executing the command that retrieves bulk data from SQL database.

I tried using the following code"

Set cnn = New ADODB.Connection
......
cnn.open ......
cnn.CommandTimeout = 100

Set rst = New ADODB.Recordset
rst.Open "select * from table", cnn, adOpenStatic, adLockReadOnly, adCmdText

''' I tried this also
set rst = cnn.execute ("select * from table")

Is there a work around for my problem?