making database read only ture then false makes any diffrence?
-
dimanche 17 février 2013 06:32
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.
- Modifié rajemessage dimanche 17 février 2013 08:09
Toutes les réponses
-
dimanche 17 février 2013 12:21
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
- Proposé comme réponse SathyanarrayananS mercredi 27 février 2013 02:11
- Marqué comme réponse rajemessage dimanche 17 mars 2013 04:45
-
lundi 18 février 2013 06:26
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
- Marqué comme réponse Eileen ZhaoMicrosoft Contingent Staff, Moderator lundi 25 février 2013 07:14
.png)
