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.
| Author |
Topic |
|
Pushpa81
Starting Member
5 Posts |
 Posted - 2008-11-06 : 04:00:03
|
| Hi all,Im modifiying a stored procedure written by a previous programmer.It is suppose to check the email address and send email to the receiptions. The send email codes are as below. (IT145 is a linked server)IF @EmailAdd = '' BEGIN SET @Error = 1 ENDELSE BEGIN exec IT145.master.dbo.xp_startmail EXEC IT145.master.dbo.xp_sendmail @recipients = @EmailAdd, @query = '', @subject = '[ Leave Application Report ]', @message = @Message, @attach_results = 'FALSE', @width = 250 exec IT145.master.dbo.xp_stopmail ENDHowever an error appears:System.ArgumentException: A severe error occurred on the current command. The results, if any, should be discarded.SQL Mail session started.When click continue, the email gets send but Im confuse wat this erros means and how to fix it.... Pls help!!!! |
|
|
|
|
|
SQL Mail error - SQL Server 2000