Hi,

Would anyone know what the syntax is for setting a database to read only via
OSQL?

Thanks,

hi Jen,
"Jen" <Jen@discussions.microsoft.com> ha scritto nel messaggio
news:63094C30-A94B-4BF9-8CD2-CE4C1E1D3B0A@microsoft.com
[quoted text, click to view]

have a look at ALTER DATABASE statement...

ALTER DATABASE db_name
SET READ_ONLY
GO
ALTER DATABASE db_name
SET READ_WRITE
GO
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply