February 27, 2008 at 11:54 am
Hello,
Can I please know the command to test the SQL email via query analyzer,
Thanks,
Devinder Sohal
February 27, 2008 at 12:16 pm
Use sp_send_dbmail. Use BOL for details.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2008 at 12:25 pm
If you are referring to SQL mail - not database mail - then just run xp_startmail.
If SQL mail is working it will simply give you a warning that mail is already started. However, if something is wrong with SQL mail, it will give you an error.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 28, 2008 at 8:37 am
You need to send mails using xp_sendmail option.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply