Check for record lock - 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

General SQL Server Forums

New to SQL Server Programming

Check for record lock

Author

Topic

issammansour
Yak Posting Veteran

51 Posts

Posted - 2007-04-16 : 11:43:59

Hi,

Any one can help me with the following requirement:-

. Checking the record if its lock before issues any statement

Any sample will be helpful

Best Regards

X002548
Not Just a Number

15586 Posts

Posted - 2007-04-16 : 12:31:41

Why?

You should just let SQL Sevrver handle the locking strategy

look at sp_lock

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

issammansour
Yak Posting Veteran

51 Posts

Posted - 2007-04-16 : 13:35:45

1. waiting for long time for user B to release the record this situations not allow on the application.

2. We need to check the record status before starting a long operation on the database.

3. SQL Server handles the locking strategy that’s fine to me, but what I need to check the status of the record before stating.

4. I try to use sp_lock NO STATUS For the record.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources