December 2, 2008 at 10:34 pm
I have made one script to data insert in 10 tables.
I will take half hour to run..
I wanto to locak those table initially , so nobody can insert recoreds on those tables during running script. and after completion of script i want to release locks.
Please give me idea for that
December 2, 2008 at 10:52 pm
You could use locking hints like TABLock or HoldLock. Alternatively you could set a higher transaction isolation level and do your inserts. Bear in mind that these have their own "side effects" . It would be better if you explain in detail what you want.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy