>>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!
>
>Take them offline
>

>-- offline
>sp_dboption 'northwind', 'offline', 'true' 
>-- back online
>sp_dboption 'northwind', 'offline', 'false' 
>

Perfect. Thank you!