making database read only ture then false makes any diffrence?
-
Sonntag, 17. Februar 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.
- Bearbeitet rajemessage Sonntag, 17. Februar 2013 08:09
Alle Antworten
-
Sonntag, 17. Februar 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
- Als Antwort vorgeschlagen SathyanarrayananS Mittwoch, 27. Februar 2013 02:11
- Als Antwort markiert rajemessage Sonntag, 17. März 2013 04:45
-
Montag, 18. Februar 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
- Als Antwort markiert Eileen ZhaoMicrosoft Contingent Staff, Moderator Montag, 25. Februar 2013 07:14
.png)
.png)
