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 is the difference between insensitive and scroll cursor?
What are the different types of data sources in ssrs?
Explain error handling in ssis?
Why SQL Agent is used?
Can two tables share the same primary key?
Where to find ntwdblib.dll version 2000.80.194.0?
What do we need queues in sql service broker?
What is difference between count (*) and count 1?
What are the steps you will take to improve the performance of a poor performing query?
Which are the new data types introduced in sql server 2008?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Why normalization is used?
Explain the properties of subqueries in sql server?
How many columns can we include on clustered index ?