0
Answer

lock database sql2005

salim

salim

15y
4k
1

hiiiiiii

i am using  storeprocedure 

 so how to lock sql 2005 database,so that i  could execute  the Store procedure 
and  i want  that  nobody can edit or update oe access the database while  Store procedure is running

 another thing is , this Store procedure   take 1 hour

 




any ideas are appreciated