Patti:

The script has an error....I was using SetMessages as my stored proc for having my custom error messages. You can remove that piece of code from the first proc usp_DropDB and you will be fine or alternatively you can make a change to the usp_ForceDropDb stored procedure and replace the statement in the end:

"EXEC usp_DropDB @DatabaseName"

with

SET @DatabaseName = QUOTENAME(@DatabaseName)

EXEC ('DROP DATABASE ' + @DatabaseName )

Hth,

Rahul

Rahul Sharma

Senior Database Administrator

Manhattan Associates

Atlanta, GA