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
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is inline variable assignment?
What is snapshot replication?
Explain transaction server implicit?
What is dknf in normalization form?
what is the difference between openrowset and openquery?
What are character string data types in ms sql server?
How to delete a database in ms sql server?
How global temporary tables are represented and its scope?
What are scalar functions in sql?
can any body tell me how to know the password of current user in sql server
How do I debug a stored procedure in sql server?
How can you insert values in multiple rows using one Insert statement?
Explain what are various ways to enhance the ssrs report?
How to send email from database?