xp_Startmail - SQL Server Forums

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 Administration (2000)

xp_Startmail

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-02 : 07:32:25

Pankaj writes "Hi,

I am facing one problem please help me.
I want to send mail through Sql Server 2000 using (xp_sendmail)
I started Sql Server Agent services

but when i am trying to run xp_startmail 'mail identity','password'

it's giving error
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80004005

I have Outlook express, Windows 2000 and Sql Server 2000

please suggest me how to use mail features of Sqlserver

Thanks in advance

Pankaj Dwivedi"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2003-10-02 : 12:29:58

might help.......

http://www.sqlteam.com/item.asp?ItemID=401

there are plenty of other items and posts to do with sql mail on this site.

Try a search from the home page........

http://www.sqlteam.com/SearchResults.asp?SearchTerms=sql+mail&SUBMITs1=Search

====
Paul

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-02 : 12:52:47

You'll need the Outlook client and not Outlook Express. You also need to configure SQL Mail prior to running xp_startmail the first time. Google "configure SQL Mail" and you'll find a great MS article that explains the steps in details.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources