How to Configure and work with SQL mail

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

General SQL Server Forums

New to SQL Server Programming

How to Configure and work with SQL mail

Author

Topic

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-06-16 : 07:49:32

Hi

How to work with SQL mail and How to Work with SQL mail

can some body help me

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2006-06-16 : 16:17:35

1. Install Outlook 2000 client on Host where SQl Server is running.
2. Configure Outlook profile
3. create MSSQLMail profile
4. For Set up SQL Mail:

1. Restart the SQL Server and its Agent
2. Expand a server group from Enterprise Manager and then expand a server
3. Expand Support Services, right-click SQL Mail, and then click Properties
4. In the Profile name list, type or select the MSSQLMail mail profile that you configured for SQLMail
5. Click Test to check the ability of the system to start and stop mail client services with the profile entered

Last Step:

following from query analyzer to test the SQLMail functionality.
xp_sendmail ‘your email address’,’message’

With Regards
BSR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources