In this case it's actually a contention issue on the application side and there aren't any deadlocks in the database. I'm attempting to find the actual sql to determine whether...

Thanks!

Is the get sql function available on all versions of sql server 2000, or after a particular service pack?

Joe

I was afraid of that. I was hoping there was a way to tie the bucketid from the syscacheobjects or use another system table so I wouldn't have to worry...

Unfortunately, I get back a begin trans or some other statement, but never the actual sql.