How to Execute an Operating System Command From Within SQL
Server ?
Answers were Sorted based on User's Feedback
Answer / sanjeev kumar
If your server is not configured for "xp_cmdshell" command
then at first you need to reconfigure for that. To
reconfigure, execute the following:-
sp_CONFIGURE 'xp_cmdshell', 1
GO
RECONFIGURE
GO
Then execute the following:-
EXEC master.dbo.xp_cmdshell 'Dir c:\'
Regards
Sanjeev kumar
Contact If your problem are still not solved.
thanks
skdeveloper0@gmail.com
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / thatiparthi brahma reddy
EXEC Master.dbo.xp_cmdshell 'Dir d:\'
Is This Answer Correct ? | 3 Yes | 0 No |
What is a non equi join?
What purpose does the model database server?
What are various limitations of the views?
What is Covering Indexes? Plz explain with example
How do I get to sql server configuration manager?
How to query multiple tables jointly?
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
How to Run a Query on a Remote SQL Server?
Tell me what is normalization? Explain different forms of normalization?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How to perform key word search in tables?
what is the difference between table and view