Change Recovery Model: Without GUI

I need a script that I can change the SQL Server 2000
database from Recovery Model: Full to Simple.
Please help me with this task?
Dan
alter database FOO set recovery simple
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:17ea901c449a8$fffd24d0$a501280a@.phx.gbl...
> I need a script that I can change the SQL Server 2000
> database from Recovery Model: Full to Simple.
> Please help me with this task?
> Dan
|||alter database [your database] set recovery full
Eric Li
SQL DBA
MCDBA
Dan wrote:

> I need a script that I can change the SQL Server 2000
> database from Recovery Model: Full to Simple.
> Please help me with this task?
> Dan
|||Oops, should be set recovery simple
Eric Li
SQL DBA
MCDBA
Eric.Li wrote:

> alter database [your database] set recovery full
>