Lock tables during SELECT

[Pickles The Cat]

I am doing a transfer operation from one database to another.

During that time, I want to lock some tables so no new data can be written.

How can I do this ?

--
incognito...updated almost daily
http://kentpsychedelic.blogspot.com

Texeme Textcasting Technology
http://texeme.com

 

[Glenn Wilson]

This will depend on the database technology that you are using, ie SQL
Server 2000, or Access

 

[Sahil Malik]

Use a transaction on the command with the appropriate isolation level.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik