How to Execute an Operating System Command From Within SQL
Server ?

Answer Posted / guest

The xp_cmdshell extended store procedure makes it possible
to execute operating system commands from within SQL
Server.
Example:

EXEC Master..xp_cmdshell 'Dir c:\'

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SQL Azure Federations?

108


How to list all columns in a table using odbc_columns()?

761


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

781


What types of Joins are possible with Sql Server?

816


What is table valued function and scalar valued functions?

732


What are the benefits of normalization?

839


what is bit datatype? : Sql server database administration

683


Why transaction is important?

747


Mention the different types of triggers?

736


Why is replication required on the sql server?

806


What is lookup override?

792


How to use user defined functions in expressions?

762


What does the not null constraint do?

784


What is measure group, measure? : sql server analysis services, ssas

797


To which devices can a backup be created and where should these devices be located? : sql server management studio

770