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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock_Wait_Period

Status
Not open for further replies.
PNC

PNC

MIS
Jun 7, 2001
87
US
Hi,

What's the equivalent in SQL Server of the server settings in Sybase [lock_wait_period]???

Thanks.
 
Sort by date Sort by votes
I believe you can set this up on the server with the following command:
sp_configure "lock wait period" [, no_of_seconds]

It can be over ridden with a session level command of:

set lock {wait no_of_seconds | nowait}
 
Upvote 0 Downvote
The configuration option 'lock wait period' does not exist in SQL Server, is there an alternative???

I don't want to use SET LOCK because it's only on the session level.

Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top