Sunday, February 17, 2013 6:32 AM
i want to make my database read only by setting its property form property dialog box,
then again when ever i want to change any table description then i want to make it read only false ,
then again read only true.
is there any harm in this procedure,
- Edited by rajemessage Sunday, February 17, 2013 8:09 AM
Sunday, February 17, 2013 12:21 PM
Hope the below links will give some idea :
Different ways to make a table read only in a SQL Server database:
Thanks & Regards, sathya
Monday, February 18, 2013 6:26 AM
it won't affect your database, but it may affect the performance of your database server.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
MCSE Data Platform
MCITP: SQL Server 2008 Administration/Development
MCSA SQL Server 2012
MCTS: SQL Server Administration/Development
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 7:14 AM