How to make a database be read-only?

Thanks ^.^ALTER DATABASE [name] SET READ_ONLY
To reverse this,
ALTER DATABASE [name] SET READ_WRITE
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OMV$aA2rEHA.1568@.TK2MSFTNGP10.phx.gbl...
> Thanks ^.^
>|||thanks
In SQL online book, it said that publish data to a read-only Subscriber
database
if the database is read-only, how can I pull the replicated data to
Subscriber'
Thanks|||I think that Books Online tries to say that you should *consider* the data to be read-only, and make
sure that you don't do any modifications in the database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:ultAjh2rEHA.2764@.TK2MSFTNGP11.phx.gbl...
> thanks
> In SQL online book, it said that publish data to a read-only Subscriber
> database
> if the database is read-only, how can I pull the replicated data to
> Subscriber'
> Thanks
>