To Remove Restricted User
security-audit #security-audit#user
Use [databasename]
ALTER DATABASE [databasename] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [databasename] SET MULTI_USER
GOUse [databasename]
ALTER DATABASE [databasename] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [databasename] SET MULTI_USER
GO