Hi Everyone:
I need to modify my database, such as adding some columns and moving some data among tables...I have written T_sql code to do this...my question is that when I am running my sql code, I need to stop all current connections to my database and stop user from reading from or writing into the database and also disallow any new connection to the database until my sql code running is done. I am wondering if there is a sp or any way to do this? Can anyone please give me some suggestions how I should do it? Thanks alot...
I need to modify my database, such as adding some columns and moving some data among tables...I have written T_sql code to do this...my question is that when I am running my sql code, I need to stop all current connections to my database and stop user from reading from or writing into the database and also disallow any new connection to the database until my sql code running is done. I am wondering if there is a sp or any way to do this? Can anyone please give me some suggestions how I should do it? Thanks alot...