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
What is ssl in sql server?
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?
What is the order in which the sql query is executed?
What is an entity-relationship diagram (erd)?
Define tempdb database?
How to assign new column names in a view?
What are the joins in sql server? : sql server database administration
What is stretch database in sql server?
How do you rebuild an identity column?
what do you understand by change data capture?
whats the maximum size of view state??
What are triggers in ms sql server?
How to get all stored procedures in sql server?
What is the process of normalising?
How can change procedure in sql server?