Explain sp_configure commands, set commands?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is a synonym for manipulation?
What is the difference between for xml raw and for xml auto?
What are the types of subquery?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How much space does sql server 2016 take?
What sql server means?
What do you understand by triggers and mention the different types of it?
What are the parts of a function?
What is service broker?
What is index?
What is normalization? Describe its different types.