March 4, 2003 at 1:22 pm
I want to make my dababase offline so that no one can enter data in it. Is it ok if I change the Database property to readonly in the options tab.
Is there any other way to make my database offline.
thanks in Advance
March 5, 2003 at 5:14 am
Readonly prevents data entry but does allow data access. If you want to set the DB actually offline and not available for use then use sp_dboption procedure
sp_dboption 'dbnamehere', 'offline', [true|false]
true for offline or false to make online again
March 5, 2003 at 5:40 am
Another option is to just detach it.
Andy
March 5, 2003 at 10:58 am
Thanks a lot.
I can consider both the options.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply