>I have about 100 SQL Server 7 databases that I am trying to migrate to 2005. What I would like to do is disable the old database after I think it's completely migrated, just in case I miss something. What's the easiest way of doing this? I know I can mess with the user's permissions, but some of the permissions are somewhat elaborate and I don't want to have to remember them weeks from now. Plus, there can be more than one user set up in a database.
>
>I'm sure it has something to do with setting an explicit "deny" permission on something. Emphasis on easy disable and easy re-enable. Thanks!
You can take offline or detach
http://blog.sqlauthority.com/2007/04/25/sql-server-2005-take-off-line-or-detach-database/