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)
 Row Locking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-06 : 09:33:25
Nick writes "I am writing a db solution that requires users to select a number of records (say 10 for example) from a table and decide if they want the records, at which point I set a field to true and these records can't be viewed by this process, but. While the user is looking at the records I DON'T want other people who are going through the same process to pull down the same records.

I'm using SQL2000 with no SP's on NT2000 Server with SP 1

Thanks."
   

- Advertisement -