USE [sp]
GO
/****** Object:  StoredProcedure [dbo].[write_to_file]    Script Date: 09/10/2016 23:24:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[write_to_file]
  @msg VARCHAR(5000),
  @file nvarchar(MAX),
  @overwrite BIT = 1
AS

/*
  Tested on: SQL Server Version 7.0, 2000
  Remarks: You should have permissions required through access file system through xp_cmdshell
           See SQL Server Books Online for xp_cmdshell if you are having problems with this procedure
*/

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