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 |
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"] |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-06-12 : 11:17:08
|
Hiexec 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 subjectwhat should be the problem.Vic |
|
|
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. |
|
|
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. |
|
|
|
|
|