ALTER DATABASE oldDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE oldDBname MODIFY NAME =newDBname ALTER DATABASE newDBname SET MULTI_USER
Month: September 2011
Mother Teresa’s Anyway Poem People are often unreasonable, illogical and self centered; Forgive them anyway. If you are kind, people may accuse you of selfish, ulterior motives; Be kind anyway. If you are successful, you will win some false friends and some true enemies; Succeed…
IF EXISTS (SELECT name FROM sys.databases WHERE name = N’dbname’) DROP DATABASE [dbname] GO