Writing to Text File

				
--**************************************
-- Name: Writing to Text File
-- Description:With this Stored procedure you can log messages to a text file
-- By: Anees Ahmed
--
-- Inputs:@text VARCHAR(100)=what is the message you want to enter
@file VARCHAR(100)=what is the file name
@overwrite BIT = 0
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=695&lngWId=5--for details.--**************************************

CREATE PROC writing_2_file
@text VARCHAR(100),
@file VARCHAR(100),
@overwrite BIT = 0
AS
BEGIN
	SET NOCOUNT ON
	DECLARE @query VARCHAR(255)
	SET @query = RTRIM('echo ' + COALESCE(LTRIM(@text),'-') + CASE WHEN (@overwrite = 1) THEN ' > ' ELSE ' >> ' END + RTRIM(@file))
	EXEC master..xp_cmdshell @query
	PRINT @query
	SET NOCOUNT OFF
END
GO