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 |
|
lm007
Starting Member
5 Posts |
 Posted - 2008-07-07 : 01:04:55
|
| I want to examine the locks taken by a SELECT query. Is HOLDLOCK appropriate? Will HOLDLOCK simply just extend the duration of whatever locks are taken or do more that that – change the number and type of locks. The documentation specifies that HOLDLOCK is equivalent with SERIALIZABLE hence I am afraid that it will do more than simply extend the lifespan of the locks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-07 : 22:50:25
|
| That's correct, you have more time to check locks used with that hint. |
 |
|
|
|
|
|
How to view locks during a SELECT query? HOLDLOCK?