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 |
|
Sepahram
Starting Member
8 Posts |
 Posted - 2001-09-26 : 06:19:00
|
| HI all,I have a stopred prodedure with a transaction in it , which includes some static and dynamically made statemenst using EXEC (). When a client executes the proc through a connection , it lock resourses. Obviousely if the client crashes before committing , the resource would be locked until admin kills the connection.The problem is that , I don't want clients to lock any resource in the proc. I tried all table hints and isolation hints , but they didn't work. How can I tell the proc not to lock tables?Yours,A. Sepahram |
|
|
|
|
|
Locking in Transaction