Many times we want to restore the existing database or do DDL operation and often we are getting error Database is in use.
ALTER DATABASE databasename SET single_user WITH ROLLBACK IMMEDIATE
You required only DBO rights on the target database, even you don't have sysAdmin rights it will work for that particular database.
No comments:
Post a Comment