SET LOCK_TIMEOUT - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SET LOCK_TIMEOUT

Author

Topic

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2004-06-09 : 05:46:02

While trying to resolve some locking-issues I need to set the lock-timeout for one of my procedures that is causing problems. Where do I set this statement? Is it like this:

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET LOCK_TIMEOUT 1500
GO

CREATE PROCEDURE dbo.procedurename
  @ID
BEGIN
  --> stuff
END

SET LOCK_TIMEOUT -1
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON 
GO

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources