March 25, 2010 at 10:35 am
I have a database that is read-only. Is there a way to create a role or change the permissions (such as for the Admin) to be able to write/update to this database while keeping it's Read-Only status? Whenever i need to make a change to it i would have to unlock it making it available for all users to write to it.
March 25, 2010 at 11:37 am
You can't modify it while it's Read Only. You'll have to turn it off & turn it back on.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 25, 2010 at 11:40 am
Thanks for the answer. This should put the question to rest.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply