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-09-08 : 07:16:38
|
| Shub writes "Here is what I am trying to do, after a user clicks a certian button in the client application I fire a stored proc in Server A that takes the rows of a ceratin table and bcp's it to a text File using xp_cmdshell. After the text file is created I would like to move it to a different server, Server B at a specified folder all in the same stored procedure that gets executed from Server A. How do I accomplish that? What are the steps? Users executing this stored procedure will not have SA rights.Any help in this matter will be greatly appreciated.ThanksShub" |
|
|
|
|
|
Copying a Text file from a SQL Box to Another SQL Box