Sniff through this technet article ... I think you will find most of your answers ...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Try this ...

Select DateAdd(mm, DateDiff(mm, 0, dateadd(mm, -1, Getdate())),0) -- First date of previous month

Select DateAdd(dd, -1, DateAdd(mm, DateDiff(mm, 0, Getdate()),0)) -- Last date of previous month

THis might do the trick as well ...

ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

go

Yet another way to skin a cat ...

exec sp_MSforeachdb "if '?' not in ('master','model','tempdb','distribution') begin alter database '?' set recovery SIMPLE WITH NO_WAIT end"