How to send the email(gmail) in Database(sql serve

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to send the email(gmail) in Database(sql serve

Author

Topic

mpolaiah
Starting Member

24 Posts

Posted - 2009-05-07 : 05:38:42

Hi All,

How to send the email(gmail) in Database(sql server 2000).

regards
polaiah

greeny122229
Starting Member

25 Posts

Posted - 2009-05-07 : 10:06:42

CREATE PROCEDURE ProcSysEmailIssuer
AS
SET NOCOUNT ON
SET @inpmessage = 'test'

EXEC Master.dbo.xp_smtp_sendmail
@FROM = 'a@a.com',
@FROM_NAME = 'matt',
@TO = 'b@b.com',
@subject = 'test',
@message = 'your text',
@server = 'your email server',
@type='text/plain'

BEGIN
EXEC ProcSysEmailIssuer
END

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-05-11 : 11:46:13

For SQL 2000, use xp_sendmail. Look up the various paramters in BOL. xp_smtp_sendmail is a third party tool that can be downloaded, created and used.

Terry

-- Procrastinate now!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources