Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ACID (LOCK) parameters

Status
Not open for further replies.
manmaria

manmaria

Technical User
Aug 8, 2003
286
US
Where do I see the default lock parameters? How do I change the configuration?

Thanks,
 
Sort by date Sort by votes
you don't change how SQL server locks records. You can specify a query hint WITH NOLOCK. But you could get a dirty read and have incorrect data. Why do you want to change these settings?

- Paul
10qkyfp.gif

- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

stanlyn
  • Locked
  • Question
Lockdown all databases except one
Replies
1
Views
81
niall5098
niall5098
tdrclan
  • Locked
  • Question
lock time out request
Replies
0
Views
21
tdrclan
tdrclan
jsteph
  • Locked
  • Question
Advice on how to interpret Svr 2008 Perf Mon. Lock Requests
Replies
0
Views
24
jsteph
jsteph
Jackmetickler
  • Locked
  • Question
Lock records
Replies
3
Views
26
Jackmetickler
Jackmetickler
wbodger
  • Locked
  • Question
SQL 2K locking issue
Replies
2
Views
13
wbodger
wbodger

Part and Inventory Search

Sponsor

Back
Top