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 |
|
space
Starting Member
1 Post |
 Posted - 2012-11-02 : 03:58:00
|
| Hello guys,A write operation would normally block when it cannot acquire exclusive lock. Is it possible to configure the db or transaction in such a way that the write would fail rather than wait? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-11-02 : 17:35:55
|
| Not that I know of. If you care to ellaborate on your scenario, we might be able to offer an alternative. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-02 : 17:45:32
|
| Not specifically...you could SET LOCK_TIMEOUT but I'm not sure if that would give you the desired result.-Chad |
|
|
|
|
|
|
Concurrent writes under SNAPSHOT READ COMITTED