Within a Stored Procedure, I'm trying to write large text
to a text file. Everything works fine until the text gets over 4k.
I then get a network error. (The file is being written to the
hard drive on the server where sql server is.)
I'm doing this so I can bring that textfile back into a table
as an image (in order to do full-text indexing with an ".htm" filter).
Any help would be greatly appreciated.
Here is a the portion of the code that writes the text file:
CREATE PROCEDURE spWriteTextFile
set nocount on
--Create Text File
set nocount off