Explain sp_configure commands, set commands?

Question Posted / guest

3 Answers
13116 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain sp_configure commands, set commands?..

Answer / senthil ku,mar

Use sp_configure to display or change server-level
settings. To change database-level settings, use ALTER
DATABASE. To change settings that affect only the current
user session, use the SET statement

Is This Answer Correct ?

7 Yes

0 No

Explain sp_configure commands, set commands?..

Answer / bhasskar

sp_configure :
The xp_cmdshell option is a server configuration option
that enables system administrators to control whether the
xp_cmdshell extended stored procedure can be executed on a
system.
—- To allow advanced options to be changed.

EXEC sp_configure ’show advanced options’, 1

GO
—- To update the currently configured value for advanced
options.

RECONFIGURE

GO

—- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

—- To update the currently configured value for this
feature.

RECONFIGURE
GO
SET:
This command is used to set the values to the variables
ex:
declare @id int
set @id=2

Is This Answer Correct ?

1 Yes

0 No

Explain sp_configure commands, set commands?..

Answer / bhaskar

Use sp_configure to display or change server-level
settings. To change database-level settings, use ALTER
DATABASE. To change settings that affect only the current
user session, use the SET statement.

E.g.

sp_CONFIGURE ’show advanced’, 0
GO
RECONFIGURE
GO
sp_CONFIGURE
GO

You can run following command and check advance global
configuration settings.

sp_CONFIGURE ’show advanced’, 1
GO
RECONFIGURE
GO
sp_CONFIGURE
GO

Is This Answer Correct ?

1 Yes

0 No

Post New Answer