Delete logins member fixed server roles

5. Delete logins member fixed server roles

Pergi ke Tools dan klik SQL Server Query Analyzer
Pilih database master (ape-2 je pun takper..saje je gua pilih master)
Taip command seperti dibawah (highlight text , klik kanan & pilih menu copy)

Klik DISINI untuk highlight kod. (Keyboard shortcut: Ctrl+C.)

Paste command tersebut pada SQL Server Query Analyzer
Run command tersebut (tekan ctrl+F5 utk compile dan F5 utk run)
( Tekan nie lepas tu tekan nie plak )
Check pada SQL Server Enterprise manager (Security - Server Roles)
Klik kanan pada System Administrator dan klik properties.
Logins Figo akan terpadam pada security roles tersebut.

Syarat:

Only members of the sysadmin fixed server role can execute sp_dropsrvrolemember to remove any login from a fixed server role. Members of a fixed server role can remove other members of the same fixed server role.

[back]