Bring database online

I have seen a db_option that would take the database offline , but how do
you bring it online again ?
Is offline similar to detaching the database ? Using SQL 2000
ThanksALTER DATABASE pubs SET OFFLINE
go
ALTER DATABASE pubs SET ONLINE
go
SQLVarad(MCDBA-1999,MCSE-1999)
>--Original Message--
>I have seen a db_option that would take the database
offline , but how do
>you bring it online again ?
>Is offline similar to detaching the database ? Using SQL
2000
>Thanks
>
>.
>|||SP_dboption is provided only for backward compatibility and this system
procedure may not be there in next version.
So as "Vyas" suggested you can use ALTER database command to set the
set/reset database options.
FYI, the command used to set the database online using db_option:-
sp_dboption <dbname>,'offline',false
Thanks
Hari
MCDBA
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:edPvvTWpDHA.372@.TK2MSFTNGP11.phx.gbl...
> I have seen a db_option that would take the database offline , but how do
> you bring it online again ?
> Is offline similar to detaching the database ? Using SQL 2000
> Thanks
>