Drop Login and User

-- 殺掉DB裏所有的相關帳號.殺之前要先解除該帳號相關連的作業,如AGENT...

-- Drop Login and User
DECLARE @account sysname = 'dbaccount'
DECLARE @dbname sysname
DECLARE @s1 varchar(max)
BEGIN
SET @s1 = 'USE master; DROP LOGIN ['+@account+']; '
EXEC (@s1)
END

DECLARE dropacc CURSOR FOR SELECT name FROM sys.databases
OPEN dropacc FETCH NEXT FROM dropacc INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
SET @s1 =
'USE '+@dbname+'; DROP USER ['+@account+']; '
EXEC (@s1)
FETCH NEXT FROM dropacc INTO @dbname
END
CLOSE dropacc
DEALLOCATE dropacc

-- 參考:我自己