making database read only ture then false makes any diffrence?
-
Sunday, February 17, 2013 6:32 AM
Hi,
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,
yours sincerely.
- Edited by rajemessage Sunday, February 17, 2013 8:09 AM
All Replies
-
Sunday, February 17, 2013 12:21 PM
Hi,
Hope the below links will give some idea :
Different ways to make a table read only in a SQL Server database:
http://sathyadb.blogspot.in/2012/10/sql-server-2012-database-read-only.html
Thanks & Regards, sathya
- Proposed As Answer by SathyanarrayananS Wednesday, February 27, 2013 2:11 AM
- Marked As Answer by rajemessage Sunday, March 17, 2013 4:45 AM
-
Monday, February 18, 2013 6:26 AM
Hi,
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
MyBlog
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 7:14 AM
.png)
