-
TSQL - Syntax for READ ONLY??
Is it possible to put a database into READ ONLY mode from MULTI USERS mode? I know that the following script will bring a database out of READ ONLY---
ALTER DATABASE foo SET SINGLE_USER WITH ROLLBACK IMMEDIATE
restore database foo
with recovery
ALTER DATABASE foo SET MULTI_USER
-
Yes, just replace 'single_user' with 'read_only'.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|