How Can I Prevent any activity on a SQL Server

I'm getting close to migrating my db's across to a new server and wonder
what is the best way to prevent users from accessing any of the db's on the
sql server?
I have a very LARGE dts package to run that will do all the work for me but
it will be running on the destination server and not sure how I can prevent
anyone other than telling them not to attach to it.
One thought was to start the server in single instance mode but I'm
unfamiliar with how it works. I could reorg the dts to run on the source
server if the single instance will do the trick.
--
Thanks
Paul BergsonHow about putting the source DB in read only mode?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>|||If you only have a few, you could do:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Then hope your DTS package jumps in before anyone else does.
The downside is you will not be able connect directly to the database to
monitor anything... you will have to rely on the DTS package.
Another idea perhaps is to rename the database? Other applications that
expect it to be there will break, but if you have told the users the db
would be down/inaccessible, that's probably acceptable.
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>