I am trying to develop email functionaliity.
I tryed creating this sproc:
CREATE PROCEDURE sp_STML AS
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM_NAME = 'Howard Kline',
@TO = '[email protected]',
@subject = 'Hello SQL Server SMTP Mail',
@server = 'caexmta5.amd.com'
select RC = @rc
GO
I get rc = 1 when I execute this.
What am I doing wring
Any ideas?
Thanks.:confused:
