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 |
|
oahu9872
Posting Yak Master
112 Posts |
 Posted - 2005-09-06 : 11:48:38
|
| Does anyone know how to upload text files to a server using a stored procedure?Thanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-09-06 : 15:07:52
|
| You can use BULK INSERT, but it requires sysadmin or bulkadmin server role.---------------------------EmeraldCityDomains.com |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-07 : 00:30:42
|
| What do you mean by upload? Are you wanting to import them into tables, or just "copy" them to a server? Where are they originally located (other server/directory, ftp, etc)?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Upload Text File with Stored Procedure