force simple recovery for all new db's

I am running ms sql 2000 for a shared database environement that each
department uses for thier own internal database needs. There are
roughly 40 active databases, and even the r&d group throws databases
up there for testing.
I need to know where to go in order to force all new db's to use the
"simple" recovery method. Currently, I have to go to the box every
week and look for any new db's, then I manually change the recovery
model.
I have looked through the model db, but I am a little uncertain what
values need to be changed to facilitate my needs.
Any help would be greatly appreciated.
Thanks,
David
SELECT 'ALTER DATABASE '+name+' SET RECOVERY SIMPLE;'
FROM master.dbo.sysdatabases
WHERE DATABASEPROPERTYEX([name], 'Recovery') != 'SIMPLE';
Aaron Bertrand
SQL Server MVP
"buster" <funkdm1@.yahoo.com> wrote in message
news:1185801388.569742.86590@.m37g2000prh.googlegro ups.com...
>I am running ms sql 2000 for a shared database environement that each
> department uses for thier own internal database needs. There are
> roughly 40 active databases, and even the r&d group throws databases
> up there for testing.
> I need to know where to go in order to force all new db's to use the
> "simple" recovery method. Currently, I have to go to the box every
> week and look for any new db's, then I manually change the recovery
> model.
> I have looked through the model db, but I am a little uncertain what
> values need to be changed to facilitate my needs.
> Any help would be greatly appreciated.
>
> Thanks,
> David
>

force simple recovery for all new db's

I am running ms sql 2000 for a shared database environement that each
department uses for thier own internal database needs. There are
roughly 40 active databases, and even the r&d group throws databases
up there for testing.
I need to know where to go in order to force all new db's to use the
"simple" recovery method. Currently, I have to go to the box every
week and look for any new db's, then I manually change the recovery
model.
I have looked through the model db, but I am a little uncertain what
values need to be changed to facilitate my needs.
Any help would be greatly appreciated.
Thanks,
DavidSELECT 'ALTER DATABASE '+name+' SET RECOVERY SIMPLE;'
FROM master.dbo.sysdatabases
WHERE DATABASEPROPERTYEX([name], 'Recovery') != 'SIMPLE';
Aaron Bertrand
SQL Server MVP
"buster" <funkdm1@.yahoo.com> wrote in message
news:1185801388.569742.86590@.m37g2000prh.googlegroups.com...
>I am running ms sql 2000 for a shared database environement that each
> department uses for thier own internal database needs. There are
> roughly 40 active databases, and even the r&d group throws databases
> up there for testing.
> I need to know where to go in order to force all new db's to use the
> "simple" recovery method. Currently, I have to go to the box every
> week and look for any new db's, then I manually change the recovery
> model.
> I have looked through the model db, but I am a little uncertain what
> values need to be changed to facilitate my needs.
> Any help would be greatly appreciated.
>
> Thanks,
> David
>