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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Write to text file in stored procedure

Author  Topic 

SoftFox
Starting Member

42 Posts

Posted - 2008-01-18 : 08:27:50
I want to write to an existing text file from within a stored procedure. Is this possible? I would also like to check for the existence of the text file first and if it doesnt exist to creat it - all within a stored procedure if possible.

nr
SQLTeam MVY

12543 Posts

Posted - 2008-01-18 : 11:56:59
see
http://www.nigelrivett.net/SQLTsql/WriteTextFile.html

To check if exists
http://www.nigelrivett.net/SQLTsql/CheckIfFileExists.html



==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

SoftFox
Starting Member

42 Posts

Posted - 2008-01-21 : 05:55:29
Thank you that is very useful.
Go to Top of Page
   

- Advertisement -