|
-
Nov 4th, 2002, 04:26 PM
#1
Thread Starter
Lively Member
Help using xp_smtp_sendmail
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|