Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to disable a database temporarily
Message
From
18/02/2009 12:55:16
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
How to disable a database temporarily
Environment versions
SQL Server:
SQL Server 7.0
Miscellaneous
Thread ID:
01382686
Message ID:
01382686
Views:
84
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!
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform