SQL code to log messages to a text file on the server, from your sotred procedures and SQL scripts

CREATE PROC write_to_file
@msg VARCHAR(100),
@file VARCHAR(100),
@overwrite BIT = 0
AS



BEGIN
SET NOCOUNT ON
DECLARE @execstr VARCHAR(255)
SET @execstr = RTRIM('echo ' + COALESCE(LTRIM(@msg),'-') + CASE WHEN (@overwrite = 1) THEN ' > ' ELSE ' >> ' END + RTRIM(@file))
EXEC master..xp_cmdshell @execstr
SET NOCOUNT OFF
END