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

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?

1034

---

What is inline variable assignment?

1076

---

What is snapshot replication?

1095

---

Explain transaction server implicit?

1023

---

What is dknf in normalization form?

1109

---

what is the difference between openrowset and openquery?

1150

---

What are character string data types in ms sql server?

1342

---

How to delete a database in ms sql server?

1313

---

How global temporary tables are represented and its scope?

1011

---

What are scalar functions in sql?

1202

---

can any body tell me how to know the password of current user in sql server

2118

---

How do I debug a stored procedure in sql server?

1170

---

How can you insert values in multiple rows using one Insert statement?

1146

---

Explain what are various ways to enhance the ssrs report?

1097

---

How to send email from database?

1069

---