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 difference between stored procedure & function?
3 Answers CarrizalSoft Technologies, Concept Infoway, TATA,
Why can there be only one clustered index and not more than one?
What are views used for?
How to receive returning result from a query?
How do I run sql server 2014?
How to move database physical files in ms sql server?
internal language used in sql server 2000?
What is etl - extraction, transformation, and loading?
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is merge replication?
What is a non clustered primary key?
What are magic tables in sql server?