SELECT p.name AS [Name] ,
r.type_desc ,
r.is_disabled ,
r.create_date ,
r.modify_date ,
r.default_database_name
FROM sys.server_principals r
INNER JOIN sys.server_role_members m ON r.principal_id = m.role_principal_id
INNER JOIN sys.server_principals p ON p.principal_id = m.member_principal_id
WHERE r.type = 'R'
AND r.name = N'sysadmin'
Which is a heck of a lot easier than faffing about clicking things...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment