use master
go
IF OBJECTPROPERTY(OBJECT_ID('dbo.sp_fileop'), 'IsProcedure') = 1
BEGIN
    DROP PROCEDURE dbo.sp_fileop
    IF OBJECTPROPERTY(OBJECT_ID('dbo.sp_fileop'), 'IsProcedure') = 1
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.sp_fileop >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.sp_fileop >>>'
END
go
CREATE PROCEDURE sp_fileop;1 (
        @filename varchar(255),
        @line nvarchar(4000) = NULL
)
-- WITH ENCRYPTION
AS
/********************************************************************************/
/*	Created By :	Umachandar Jayachandran	(UC)				*/
/*	Created On :	07 November 1999					*/
/*	Description:	These stored procedures provide wrappers for creating 	*/
/*			files, inserting lines & deleting the files. Simple one.*/
/*			Can be improved by using OLE automation.		*/
/********************************************************************************/
/*	Resources  :	http://www.umachandar.com/resources.htm         	*/
/********************************************************************************/
DECLARE @cmdstr nvarchar(4000)
SELECT @cmdstr = 'echo ' + COALESCE(@line, '.') + '>' + @filename
EXEC master..xp_cmdshell @cmdstr, no_output
go
CREATE PROCEDURE sp_fileop;2 (
        @filename varchar(255),
        @line nvarchar(4000) = NULL
)
-- WITH ENCRYPTION
AS
DECLARE @cmdstr nvarchar(4000)
SELECT @cmdstr = 'echo ' + COALESCE(@line, '.') + '>>' + @filename
EXEC master..xp_cmdshell @cmdstr, no_output
go
CREATE PROCEDURE sp_fileop;3 (
        @filename varchar(255)
)
-- WITH ENCRYPTION
AS
DECLARE @cmdstr nvarchar(4000)
SELECT @cmdstr = 'DEL ' + @filename
EXEC master..xp_cmdshell @cmdstr, no_output
GO
IF OBJECTPROPERTY(OBJECT_ID('dbo.sp_fileop'), 'IsProcedure') = 1
BEGIN
    GRANT EXECUTE ON dbo.sp_fileop To Public
    PRINT '<<< CREATED PROCEDURE dbo.sp_fileop >>>'
END
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.sp_fileop >>>'
go