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

How to find related tables in sql server?

944

---

Can you explain what are various ways to enhance the ssrs report?

1002

---

What is the difference between mysql and mysqli?

1202

---

How do you clear a log file?

1047

---

Explain Normalization and DE normalization

1110

---

How to use clusters?

945

---

What is not null constraint?

1121

---

Why we need sql server?

962

---

List the advantages of using stored procedures?

1051

---

What is difference between commit and rollback when used in transactions?

959

---

Can you move the resources after pausing the node? : sql server database administration

1102

---

Do you know what are the reporting services components?

974

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1805

---

how can you attach more than 20 ldf files in sql server

2000

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---