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)
 Locking check?

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2005-02-24 : 10:26:41
Hi all i am trying to write the sp that will return if the record is being access or edited by other user so the second user cannot make any changes on the record on ly can view it.

IsThisRecordLocked

(

@RecordID int

@retval int out --0 is not locked. 1 is locked.

)


not able to understan that how to write this so please help me!!

Thanks in advance.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-02-24 : 12:16:03
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46347

Go to Top of Page
   

- Advertisement -