Answer / 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

Answer / guest

The xp_cmdshell extended store procedure makes it possible
to execute operating system commands from within SQL
Server.
Example:

EXEC Master..xp_cmdshell 'Dir c:\'

Answer / thatiparthi brahma reddy

EXEC Master.dbo.xp_cmdshell 'Dir d:\'

How do I find query history in sql server?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

How can I know what locks are running on which resource?

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---