Make Database Read Only
ALTER DATABASE [Database name] SET READ_ONLY WITH NO_WAIT
Make Database Read/Write
ALTER DATABASE [Database name] SET READ_WRITE WITH NO_WAIT
Making Database Read only or Read/Write
1 Comment
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Mayur GujrathiPosted May 6, 2011, 1:15 AM
HI Ankit by default it is READ_WRITE or not