LOCKING ISSUES 1

[svagelis]

I have one table that contains 3 columns (ID,Index,Desc)
I use this table to collect Index and Desc in order to
make a primary key to another table.After i collect index and desc , i increase the value of Index by one.
What i want is to ensure that while i m reading Index , inserting record to another table and increase index , no other user will read index and got the same value as i got.
Is there a way to prevent others from reading index while i m doing this job?
Thanks!!

 

[ColinM]

Sounds like you want to wrap this up into a transaction
Have a look at the SQL Server Books online to find out more about the TSQL command BEGIN TRANSACTION

 

[tlbroadbent]

You can use the a table hint, TABLOCKX.

SELECT IndexVal FROM table1 (with TABLOCKX)

This will lock the table exclusively for the duration of your transaction. Terry

http://members.home.net/tlbroadbent/index.htm

 

[redlam]

just reading thru today's posts and found this. cool stuff terry. thanks.
-michelle