Answer Posted / 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:\'

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1051

---

How to get @@error and @@rowcount at the same time?

1035

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1250

---

Is sql different from sql server?

1087

---

What is the difference between functions and scalar functions?

1210

---

what are constraints? : Sql server database administration

1056

---

Can select statements be used on views in ms sql server?

1065

---

How to copy data from one table to another table?

996

---

What is the Disadvantage of indexed sequential file.

1084

---

What security features are available for stored procedure?

1036

---

what is an extended stored procedure? : Sql server database administration

1055

---

Which language rdl files made of?

130

---

What is data modeling and Reterminal integrity?

1955

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---

What does the not null constraint do?

1088

---