Re-building Indexes

[SEC-ER]

WHILE REBUILDING THE INDEXES FROM DB MAINTENANCE PLAN,I NEED TO DISABLE ALL
TERMINAL SERVERS MANUALLY TO MAKE SURE THAT NO USER IS ACCESSING THE DATABASE.IT
IS MAKING DIFICULT TO COME AND DISABLE THE TERMINAL SERVERS AND ENABLE AFTER
FINISHING THE JOB(WHICH WILL TAKE 9 HOURS).I WANT WEATHER IS POSSIBLE FROM
SQL SERVER TO RESTRICT THE USERS WHILE REBUILDING INDEX JOB RUNS.
I AM VERY THANKFUL IF YOU SUJJEST ME THE POSSIBLE SOLUTION.
I tried by setting the Database option in single user mode.
REGARDS
MAM
DATABASE ADMINISTRATOR
SEC-ER-KSA(Saudi Electricty companey)

[Andrew Prosser]

"SEC-ER" <m_mussu@hotmail.com> wrote:
>
>WHILE REBUILDING THE INDEXES FROM DB MAINTENANCE PLAN,I NEED TO DISABLE
ALL
>TERMINAL SERVERS MANUALLY TO MAKE SURE THAT NO USER IS ACCESSING THE DATABASE.IT
>IS MAKING DIFICULT TO COME AND DISABLE THE TERMINAL SERVERS AND ENABLE AFTER
>FINISHING THE JOB(WHICH WILL TAKE 9 HOURS).I WANT WEATHER IS POSSIBLE FROM
>SQL SERVER TO RESTRICT THE USERS WHILE REBUILDING INDEX JOB RUNS.
>I AM VERY THANKFUL IF YOU SUJJEST ME THE POSSIBLE SOLUTION.
>I tried by setting the Database option in single user mode.
>REGARDS
>MAM
>DATABASE ADMINISTRATOR
>SEC-ER-KSA(Saudi Electricty companey)
>

You can set the database option to 'dbo use only'. When true, only the database
owner can use the database. For a good place for more in-depth information
go to http://msdn.microsoft.com/sqlserver/ which has lots of info or http://www.swynk.com/

Regards,

Andrew.