Bookmark and Share
Last Updates
Display: 1 - 2 of 2, Total Pages: 1
1
[Work Notes] How to detect a SQL Server database's read only status [Original] 2014-7-30 5:19pm
Query 1SELECT name, is_read_only FROM sys.databases GOQuery 2SELECT name, is_read_only FROM sys.databases WHERE name = 'MyDBName'GOQuery 3EXEC sp_dboption "MyDBName", "read only"

Read Full Article...

Section:MS SQL Server DBA | Read:1109 | Comment:0 | Rating:0%

[Work Notes] Change a SQL DB to read-only / read-write [Original] 2014-5-29 11:29am
-- Make Database Read OnlyUSE [master]GOALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAITGO-- Make Database Read/WriteUSE [master]GOALTER DATABASE [DBNAME] SET READ_WRITE WITH NO_WAITGO -- Make Data..

Read Full Article...

Section:MS SQL Server DBA | Read:576 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am