Question: 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, type_desc
FROM sys.server_role_members srm
JOIN sys.server_principals sp
ON srm.member_principal_id = sp.principal_id
Group of answer choices
it uses catalog views to display information about members of server roles
it cross-checks 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

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!

Q:

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Q:

[6 - I-lH Gregg: Deciding on a New Information Technology Platform 177 Midsouth Chamber of Commerce (B): Cleaning Up an Information Systems Debacle As Sage Niele, the newly appointed Vice President...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Answer the following questions and write your answers clearly in the spaces provided. All questions must be answered correctly, and you must provide enough detail to demonstrate your knowledge. If...

Q:

I need the attached 33 questions answered for me today by 6pm EST. Project/Test One TXX 5769 September 14, 2015 There are 33 multiple choice questions below. Please use the posted answer sheet for...

Q:

1. Which, if any, of the following statements is not accurate? a. Every Code section has a treasury regulation. b. The current Code is the 1986 Code, as amended. c. Code sections inserted between...

Q:

Read It's Time for Principles-Based Accounting Ethics which can be accessed through the DeVry online library. In 3-4 pages (12-pt type, double-spaced) answer the following questions: Do you agree...

Q:

Part 1: Practicing Problem Analysis, Design, and Coding Step 1. Problem Statement A company named Acme Software Company needs to develop a Java application that can maintain software purchasing...

Q:

This is java. Please use the BST class provided in algs4.jar. If you do not use the BST class and post a polynonaimal program I will give a negative review. Run empirical studies to compute the...

Q:

I need to create a server using Node.js, HTTP, and mocha testing framework Instructions to complete the server.js file: use the File System module to load testings.json into memory create a request...

Q:

A company uses the periodic inventory system and had the following activity during the current monthly period. November 1: Beginning inventory 114 Units @ $30 November 5: Purchased 26 64 Units @ $64...

Q:

BMW was able to create the premium compact car segment with the introduction of the Mini. Its success has come through a differentiated product offering. It is a market leader and continues to see...

Q:

With all else held constant, a firm will have a higher P / E if its beta is higher.

Q:

Ch 1 4 . 3 Need - to - Know Videos ( i ) QS 1 4 - 1 4 ( Static ) Computing total manufacturing costs LO P 2 1 . 2 points Determine the missing amount for each separate situation involving...

Q:

Know what customers expect from the firm when they complain.

Q:

Understand why customers complain.

Q:

Know why loyalty programs and customer relationship management (CRM) systems are important enablers of delivering loyalty strategies.