摘要: 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... 阅读全文
posted @ 2010-07-31 18:48 lp123 阅读(162) 评论(0) 推荐(0) 编辑
摘要: -- =======================================================================-- SQL SCRIPT to create LOGIN in the SERVER, and assign sysadmin role to it.-- ===============================================... 阅读全文
posted @ 2010-07-31 18:29 lp123 阅读(188) 评论(0) 推荐(0) 编辑