Lock/Unlock database for Update

[hinchdog]

I'm updating SQL server from an ASP page using ADO. I want to preform to updates, however I don't want anyone to access the database until BOTH updates are complete. Does anyone know a quick way to do this - I'm guess it has something to do with lock types.

-Hinch

 

[yuben]

You can do it using a "Pessimistic" lock type. However, this will only lock the table being updated and not the database.