Where is the email relayed to, I mean to say Microsoft Outlook or yahoo/gmail etc?

Satnam

Normally in some cases the latency is high due to network issues. As per my experience when the traffic on the n/w is high and the data is getting replicated...

Uday,

Just go through the link below,

http://www.mssqltips.com/tip.asp?tip=1100

I hope this will help you to identify the mistake.

Cheers,

Satnam

Backing up a test environment is always good. What u can do is that perform a full backup on a daily basis and dont take copies of those on tape...

Excellent article paul.Couldn't ask much better than this.

Great work done.

Satnam

Pankaj,

Few weeks back, I wrote an article for http://www.sql-server-performance.com on the similar issue, the same can be referred on the below link,

http://www.sql-server-performance.com/articles/dba/email_alerts_notification_p1.aspx

Please let me know if you face any issues.

With...

Nice one.

Thanks for that Suresh. TCP/IP is already enabled on the server.

Many Thanks for that Gail. Any idea about how i introduce corruption into the data file manually,search for the page with the As and change one byte to a ‘B’...

Mike,

In my case, the table storing the email addresses of the users to whom the Newsletters were supposed to be sent was in MYSQL database.It is also not possible that...

You can send email from SQL to Outlook, Lotus Notes etc.I have implemented it for Microsoft Outlook.We need to know the relay server IP address while creating the Database Mail...

Many Thanks to you. In order to achieve the results, use the below T-SQL query:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Profile Name',

@recipients=@cs_application_email,

@copy_recipients...

update R

set WorkType = case

when WorkTypeID in(4,5,6) AND UPPER(OPNumber) LIKE '%S' AND UPPER(OPNumber) NOT LIKE 'GS%S' then 'SSR Enhancements'

...

I would recommend you to use BCP feature available in SQL Server 2000 to copy the results of the SQL query to an excel file, then use xp_sendmail mail feature...

Fantastic....