Best approach in storing file content

[rsg00usa]

I have a databases that stores log file information amongst other things. Along with that information is a path to where the actual log file resides. A colleague of mine suggested storing the file itself in the database as well. Is that a better idea? I would think keeping a pointer to where files contain is more efficient. If not how would you suggest storing it in the database (plain text, blob, ...)?

Thanks,
Scott

 

[JohnDTampaBay]

While it is possible to store a file in SQL Server, the general consensus it to store the path to file, as you have, and let the file system handle storing the file itself. Check out BOL for READTEXT, WRITETEXT and UPDATETEXT for a look at how to store and retrieve large objects. IMHO it is cumbersome and more trouble than it's worth, most of the time.
--Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
0 row(s) selected