Net Send

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.spNetSend    Script Date: 12/18/2002 9:14:03 PM ******/
ALTER  PROCEDURE spNetSend(@username varchar(100) = '*', 
@msg varchar(4000) = '',
@RetCode bit = 0 OUTPUT)
AS
DECLARE @netsend nvarchar(4000)

CREATE TABLE #netSend (outputData varchar(7800))

SET @netsend = 'net send ' + @username + ' ' + @msg

INSERT INTO #netSend EXEC master..xp_cmdshell @netsend

IF EXISTS(select * from #netSend where output like 'The message was successfully sent%')
SET @RetCode = 1
ELSE
SET @RetCode = 0

DROP TABLE #netSend


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

GRANT  EXECUTE  ON [dbo].[spNetSend]  TO [public]
GO