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)
 Record level locking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-13 : 17:51:36
Jim writes "SQL Server 7.0
When I run a select statement, I receive a number of records. I want to make sure that those records that I am working on, no one else should be able to change/delete or even read. Is there a system table or something that I can query to find out what records have been queries by the last user/application so that when somebody else tries to read/modify the same record, they get a message say they cannot do so.
Kind of a checkout type thing in sourcesafe...

Please reply,

thanks in advance.
Jim"
   

- Advertisement -