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 a schema in sql server 2005? : Sql server database administration
How to create new databases with "create database" statements?
List all the types of user-defined functions?
How to see existing views in ms sql server?
What is the osql utility?
why would you call update statistics? : Sql server database administration
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is openrowset sql server?
How to list all objects in a given schema?
Describe in brief databases and sql server databases architecture.
How will you go about resolving deadlocks?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What are types of subqueries?
How to sort query output in descending order in ms sql server?
Explain transaction server explicit transaction?