Append File Script

August 2, 2002

This simple script from Ramunas Balukonis is useful when you need to log in to a file from SQL server. The script opens a file and adds user-specified information to that file.

Usage: dbo.append_log (@file_name VARCHAR(255) /* file2appaned*/, @msg VARCHAR(8000) /* msg2log */)

You need to set permission on master..OACreate, master..OADestroy, master..GetErrorInfo, master..sp_OAMethod xps to user, wich will execute this sp. Also you need to set write permissions on file @file_name, to the account under which SQL Server is running. Also, the "Scripting.FileSystemObject" object should be installed on the server.

Download the Script

The Network for Technology Professionals


About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers