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
 Old Forums
 CLOSED - General SQL Server
 The 'subject' in SQL Mail

Author  Topic 

indra7
Starting Member

5 Posts

Posted - 2006-06-11 : 22:08:38
I'm using the following code in a trigger: (in SQL Server 2000)
And while a message is successfully sent and it includes the
appropriate message and recipient data, the subject is constantly left
blank.

Any help on this would be much appreciated.
Thanks.


declare @mes varchar(250)
declare @mes2 nvarchar(1450)


set @mes2 = (select Identified_Vuln from inserted)
set @mes = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'


EXEC master..xp_startmail
EXEC master..xp_sendmail


@recipients = 'xx...@xxxxx.com',
@subject = 'test',
@message = @mes


EXEC master..xp_stopmail

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-06-12 : 05:48:40
set
@subject = N'test',

also sending mail from a trigger is very bad


Go with the flow & have fun! Else fight the flow
Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]
Go to Top of Page

svicky9
Posting Yak Master

232 Posts

Posted - 2006-06-12 : 11:17:08
Hi

exec xp_sendmail 'vic','Backup Report','exec ab_backupreport',@subject = N'Backup report'

I am sending the email like this .
But it still has a blank subject

what should be the problem.


Vic
Go to Top of Page

indra7
Starting Member

5 Posts

Posted - 2006-06-12 : 20:42:30
First, thank you for responding. I really appreciate it.
But, I tried exactly what you suggested and it didn't work.
Go to Top of Page

rweston002
Starting Member

1 Post

Posted - 2007-05-26 : 20:28:56
I came acorss the issue with SQL server 2000 + sp4. I replaced the sqlmap70.dll with the sp3 version ( there is a different version in every sp ), restarted the sql server and voila...

I realize the last time someone responded to this post, but i'm posting just in case it helps someone in the future.
Go to Top of Page
   

- Advertisement -