DECLARE @csLogin varchar(200)
DECLARE Login_CS CURSOR FOR
SELECT name FROM sys.server_principals
WHERE type_desc in ('WINDOWS_LOGIN','SQL_LOGIN','WINDOWS_GROUP') and name <> ORIGINAL_LOGIN()
OPEN Login_CS
FETCH NEXT FROM Login_CS
INTO @csLogin
WHILE @@FETCH_STATUS = 0
BEGIN
SET @csLogin = '[' + @csLogin + ']'
EXEC( 'DROP LOGIN' + @csLogin)
FETCH NEXT FROM Login_CS
INTO @csLogin
END
CLOSE Login_CS
DEALLOCATE Login_CS;
GO
DROP LOGIN ORIGINAL_LOGIN()
GO
內文搜尋
從 APP 打開
X