Question: Hello. I am taking a Database Administration Course and I am not understanding the following questions or how to code this correctly in SQL: Your

Hello. I am taking a Database Administration Course and I am not understanding the following questions or how to code this correctly in SQL: Your assistance would be greatly appreciated.

Hello. I am taking a Database Administration Course and I am not

Query the catalog view sys.server_principals to return only the data for module4Login 4. Add a WHERE clause to modify the following query to return only the data for module4Login and execute the query 5. SELECT p. NAME as roleName, m. NAME as principalName FROM sys.server_role_members rm INNER JOIN sys.server_principals p ON rm.role_principal_id -p.principal_id INNER JOIN sys.server_principals m ON rm.member_principal_id - m.principal_id

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!