Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-10 : 06:53:34
|
| edgar carranza writes "HiI want to retrieve data from command promt ( C:> ), i try to use bcp command, but it doesn't work, i try with xp_cmdshell, but this utilities work with SQL Query Analyzerwhich utility i should use?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-10 : 06:56:07
|
| For one thing, what are you trying to capture from the command prompt, and what are you planning to do with it in SQL Server? bcp would not work at all. And if you're trying to capture user input, this will not work via Query analyzer. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-06-11 : 10:01:50
|
| Do you mean you want to load a file using a utility called from a command prompt?If so the bcp will do that but you need it on the client - it gets installed with sql client utilities or you can install it separately.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
utilities