hello all i have this wierd problem using xp_sendmailnow i have sql server 2000 on my server and i installed outlook 2000(took my a while to find but i was told it works finaly for that stored procedurenow when i run this codedeclare @recipients nvarchar(50)set @recipients='i.shoujaa@skyband.com.sa'declare @message nvarchar(500)set @message='Speed Violations: 'declare @query nvarchar(1000)set @query='select messageunit,max(messagespeed)as speed from ARAM_Tracker.dbo.tbgpsmessage where messagespeed>71 and messaegcreationdate>dateadd(hour,-48,getdate()) group by messageunit'--exec master..xp_stopmailexec master..xp_startmailEXEC master..xp_sendmail @recipients , @message , @query;exec master..xp_stopmail
i get the following errorSQL Mail session started.Msg 18025, Level 16, State 1, Line 0xp_startmail: failed with mail error 0x8004010fMsg 18025, Level 16, State 1, Line 0xp_sendmail: failed with mail error 0x80004005Stopped SQL Mail session.
i have no idea what mistake am i doing please help
sql mail problem
Posted - 2009-12-10 : 06:22:37
