How to Execute an Operating System Command From Within SQL
Server ?
Answer Posted / 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 |
Post New Answer View All Answers
Are resultset updatable?
How to round a numeric value to a specific precision?
Define indexes?
how to use DTS package in 2000,2005,2008 in sql server
please differentiate between delete and truncate?
What are the different types of sql server replication? : sql server replication
How can you find out how many rows returned in a cursor?
What is dbcc? Give few examples.
How to Insert multiple rows with a single insert statement?
What is the command to change the recovery model?
What are commonly used mssql functions in php?
What are data regions?
What do you understand by sql server agent?
Explain an automatic checkpoint
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?