摘要:
use mastergo--Get all logins with sysadmin role.select b.name,b.type,b.type_desc,c.namefrom sys.server_role_members ainner join sys.server_principals bon a.member_principal_id = b.principal_idinner jo... 阅读全文
摘要:
-- =======================================================================-- SQL SCRIPT to create LOGIN in the SERVER, and assign sysadmin role to it.-- ===============================================... 阅读全文