Untitled

IF EXISTS
(
SELECT *
FROM master.dbo.sysdatabases
WHERE [NAME] = 'DatabaseName'
)
BEGIN
--ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
;
--ALTER DATABASE [DatabaseName] SET RECOVERY FULL
;
--ALTER DATABASE [DatabaseName] SET MULTI_USER WITH NO_WAIT
;
END