How to config a Database to be read only

[Pelson2003]

Very Simple Question

How to configure a database to be read only ?

Microsoft SQL 7.0

Thanks
Nelson

 

[nigelrivett]

see sp_dboption

or right click in enterprise manager.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JayKusch]

To make it read only ...

USE master

EXEC sp_dboption MyDB, 'read only', 'TRUE'

To turn read only off ...

USE master

EXEC sp_dboption 'MyDB', 'read only', 'FALSE'

Replace "MyDB" with your true DB name.











Thanks

J. Kusch