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

What can be used instead of trigger?

1099

---

What to perform pattern match with the like operator?

842

---

Define indexes?

999

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1069

---

How to configure and test odbc dsn settings?

1100

---

What are data driven subscriptions?

106

---

Define left outer join in sql server joins?

908

---

Is it ok to shrink transaction log?

939

---

How do you test your database? : sql server database administration

955

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1009

---

What is a data collection table?

948

---

How can windows applications connect to sql servers via odbc?

1062

---

Can truncate be rolled back?

886

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

139

---

What is sql language?

1030

---