Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the steps you will take to improve the performance of a poor performing query?
How to transfer an existing table from one schema to another schema in ms sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is optimization and its types?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How to download microsoft sql server 2005 express edition?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the use of group by clause?
How can we migrate from SQL server to SQL Azure?
What are triggers? How do you invoke a trigger on demand?
What are joins in sql and what are the different types of joins?
Write an sql query to find first weekday of the month?
what is memory-optimized nonclustered indexes
Explain the third normal form(3nf)?
What is user defined stored procedures?
