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 |
|
itsmarkdavies
Starting Member
14 Posts |
 Posted - 2002-02-19 : 12:26:06
|
| I am using SQL Server 6.5 and would like to know the best way to transfer the contents of a Table to a PC on the Network as a Text file, using a Stored Procedure.The Table contains 1 Text Field and I just want to run a Stored Procedure that selects * from it, puts the data into a Text file called OUTPUT.txt and then sends the file to a Users PC Hard Disk on the Network.Thanks for your time. |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
Posted - 2002-02-19 : 12:47:01
|
| For 6.5 I believe the best way will be to use bcp utility or bulk insert.Just search BOL on bcp or bulk insert.helena |
 |
|
|
|
|
|
Transferring Text files