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 |
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-14 : 16:04:10
|
Im unable to send multiple attachment using sp_send_dbmail.SET NOCOUNT ONEXEC msdb.dbo.sp_send_dbmail @recipients='xxxx.xxxx@xxxx.org, @subject = @sub, @body = @tableHTML, @body_format = 'HTML', @profile_name = 'Refresh', @file_attachments =@2PATH;@1PATH;I only get the attachment of @2PATH file in my email.I have tried as suggested to include 'SET NOCOUNT ON'.No luckIf I were to try one variable at a time.It works fineHow do I do this ? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-14 : 16:36:05
|
Tara,I still get only the first attachment |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-15 : 14:59:21
|
Hi Tara,Print comes up with '\\xx.xx.xx.xx/d$/DailyErrorLog/DailyErrorLog.txt;\\xx.xx.xx.xx/d$/DailyErrorLog/DailyErrorLog.txt' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-16 : 09:06:30
|
Hi Tara,Yes both file names were the same.I changed it and the slashes as well.Got it to work.Thank You so much. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|