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
Does partitioning ssd reduce performance?
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?
What is the difference between varchar and nvarchar datatypes?
whats the maximum size of view state??
How to move database physical files in ms sql server?
What is the difference between an index and a unique index?
Can we use where clause in union?
What does indexation mean?
what is sql server? : Sql server database administration
Who is the owner of a schema in ms sql server?
What are the diifferences between the ms sql server vs mysql?
Do you know sql server 2008 introduces automatic auditing?
What are the 7 disadvantages to a manual system?
How many types of database relationship in sql server?
Does sql server 2016 have ssms?