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 to find the date and time of last updated table?

3 Answers  

---

What are the basic features of a trigger in ms sql server?

0 Answers  

---

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

---

What are out-of-range errors with date and time literals?

0 Answers  

---

What is multilevel indexing?

0 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---

What is log in sql server?

0 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

Explain about Views?

0 Answers   Infosys,

---