블로그는 나의 힘!
[ Programing ]/Database2021. 3. 30. 09:28

SELECT _role.Name, _role.Type_Desc, _member.Name MemberName, _member.Type_Desc
FROM sys.server_role_members AS _roleMember
     INNER JOIN sys.server_principals AS _role
           ON _role.Principal_Id = _roleMember.Role_Principal_Id

     INNER JOIN sys.server_principals AS _member
           ON _member.Principal_Id = _roleMember.Member_Principal_Id

WHERE _member.name NOT LIKE '%system%' 
      AND _member.name NOT LIKE '%SQLServer%';


'[ Programing ] > Database' 카테고리의 다른 글

[MSSQL] ERROR 15023  (0) 2021.03.30
MS-SQL 사용자 계정 조회.  (0) 2021.03.30
MS-SQL BackUp Script  (0) 2021.03.26
MS-SQL 스크립트 생성. 데이터 & 스키마 추출  (0) 2021.01.15
MS-SQL Group by 와 Distinct 성능 차이  (0) 2021.01.15
Posted by Mister_Q