Viewing 4 posts - 1 through 4 (of 4 total)
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
January 17, 2006 at 6:01 am
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
August 31, 2005 at 6:43 am
THis might do the trick as well ...
ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
July 18, 2005 at 11:00 am
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"
May 27, 2005 at 5:53 am
Viewing 4 posts - 1 through 4 (of 4 total)