How to change Recovery mode

We can use the codes below to get the recovery mode of a database:
select DatabasePropertyEx('test', 'Recovery')
Now I want to change a database's Recovery to SIMPLE.
How can I do that?Hi ad,
Try: Alter Database <DB Name> Set Recovery Simple
"ad" wrote:

> We can use the codes below to get the recovery mode of a database:
> select DatabasePropertyEx('test', 'Recovery')
> Now I want to change a database's Recovery to SIMPLE.
> How can I do that?
>
>
>