>>>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
>>
>>
>>sp_dboption 'northwind', 'offline', 'true'
>>
>>sp_dboption 'northwind', 'offline', 'false'
>>
>
>Perfect. Thank you!
You're welcome
--sb--