You want to modify the server settings without using the Server properties screen from the Management Studio. Which stored procedure allows you to change server settings?

The correct answer is A. sp_configure. sp_configure displays or changes global configuration settings for the current server. When executed with no parameters, sp_configure returns a result set with five columns and orders the options alphabetically in ascending order, as shown in the following table

Design an optimized database solution

Question

Options

Asp_configure
Bsp_bindrule
Csp_addtype
Dsp_autostats

How the community answered

(23 responses)

A
78% (18)
B
4% (1)
C
4% (1)
D
13% (3)

Explanation

sp_configure displays or changes global configuration settings for the current server. When executed with no parameters, sp_configure returns a result set with five columns and orders the options alphabetically in ascending order, as shown in the following table

Topics

#sp_configure#server settings#system stored procedures

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice