Is there a way to set the default recovery model to simple. Right now whenever a new DB is created it is set to full and those files can get huge. I need to know for both sql 2000 and 2005. If there is no way to change that by default, is there a stored procedure I could run nightly to change every database recovery model to simple. I know how to do it in sql syntax, but I don't know how to run it programatically on every DB. The first option would be preferable though. Thanks,
