Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What does this code do ? SELECT name, type _ desc FROM sys . server _ role _ members srm JOIN sys . server _
What does this code do
SELECT name, typedesc
FROM sysserverrolemembers srm
JOIN sysserverprincipals sp
ON srmmemberprincipalid spprincipalid
Group of answer choices
it uses catalog views to display information about members of server roles
it crosschecks which server role holders are also server principals
it uses system stored procedures to list the name and type of all server roles
nothing, it results in an error
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started