How to lock a table or a database using VB.NET and ADO.NET with SQL Server 2000?

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

Hi,
I have a few question regarding Locking question.

I'm using VB.NET and my Database is SQL Server 2000.

1) Certain part of my application, I need to lock the whole table to prevent
other user from using it, how should I lock it to prevent user access the
table.

2) There's one part of my application, I need to lock the whole database
(block user) when I want to transfer the records from the working table to
the storage table then release the lock after I'm done. How should I go
about doing it?

Regards
Vanessa
 
Back
Top