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 |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2004-08-03 : 14:38:46
|
| One of my client is producing reports on a AS400 system. Currently he is sending a txt file to his remote users. Now he would like to be able storing those raw txt file in a SQL Server database so he could offer some sort of friendly web user interface. Reports can be around 2Mb of text per report. Is there a way to store a text file in SQL Server as it is an retrieve it as it is as well ?jean-lucwww.corobori.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-03 : 16:19:44
|
| Yes there is and there are examples over at www.asp.net, but it is not recommended that you do this. You should be storing the files on disk and then putting the path and filename information in the database. http://www.sqlteam.com/item.asp?ItemID=986Tara |
 |
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-08-03 : 20:01:04
|
| I have done this before with an image, would it be the same with a txt file ?jean-lucwww.corobori.com |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-03 : 23:10:44
|
| Yes. And you still shouldn't do it. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Storing txt files in a SQL Server db