Attachments and SP2

After installing SP2, all subscriptions ran fine, except that none of the emails that were sent contained the attachment of the report.

Can someone help me with this problem?

Harold S.

After further investigation, it is me and only me that did not get the attachments.

Maybe someone know why?

Harold S.|||

Try delivering to a local directory instead of the SMTP server and check that the attachment is in the file we create. After that, it has something to do with your mail system.

|||Delivering to a local directory worked fine. Everyone else gets the attachment.

I can send a receive attachments without any problems except when they come from Report Services.

Harold S.

Attachment using extendet store procedures

I am trying to send SMTP email with attachment using cdosysmail and getting
error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
this store procedure is working on SQL 2000.
any help please.Perhaps @.FileSource is not a valid path/file name or the SQL Server process
does not have permissions to that resource.
"viktor" <serguienkov@.hotmail.com> wrote in message news:O4uh44XOGHA.3732@.TK
2MSFTNGP10.phx.gbl...
I am trying to send SMTP email with attachment using cdosysmail and getting
error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
this store procedure is working on SQL 2000.
any help please.|||the same procedure work fine on SQL 2000 permission is not the case
"JT" <someone@.microsoft.com> wrote in message
news:OayLaIYOGHA.1676@.TK2MSFTNGP09.phx.gbl...
Perhaps @.FileSource is not a valid path/file name or the SQL Server process
does not have permissions to that resource.
"viktor" <serguienkov@.hotmail.com> wrote in message
news:O4uh44XOGHA.3732@.TK2MSFTNGP10.phx.gbl...
I am trying to send SMTP email with attachment using cdosysmail and
getting error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any,
should be discarded.
this store procedure is working on SQL 2000.
any help please.

Attachment file is invalid.

Hello,

I have a stored procedure with this syntax

declare @.filename varchar(100)

set @.filename='c:/A.pdf'

EXEC msdb.dbo.sp_send_dbmail

@.profile_name =@.p_profile

@.recipients = @.p_address,

@.body = @.p_body,

@.subject = @.p_subject,

@.file_attachments = @.filename

but when I execute it i have an error

Attachment file c:/A.pdf is invalid.

What's happen? Thanks in advance

hi,

It seems you are trying to load the file from invalid path. Change to

@.filename='C:\A.pdf' instead of 'c:/A.pdf'

Also make sure that A.pdf file is availed in C Drive.

|||Moving to the Transact-SQL forum.

Attachment Error received

Hi all,
I've just started dabbling with SQL Express (I've an up-coming project and
would like to use it). I had no hassles connecting to the db I created in
VS2005 std but now I want to test connectin to it outside of the inetpub. I
copied the MDF and LDF to another folder on my drive and changed the conn
string to reflect this but I get the following error:
The header for file 'w:\temp\Test.mdf' is not a valid database file header.
The PageAudit property is incorrect.
An attempt to attach an auto-named database for file w:\temp\Test.mdf
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
Clearly something's gone wrong here but what would I need to do to fix this
problem (and be able to connect to SQL Express db's from other folders in
future)?
Regards
John.
Moving the database files and then not being able to attach them is usually
a permissions problem but I've never seen this error. You might try the
copy again - this error sounds like a corrupted file.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"John" <a@.b.c> wrote in message news:uhr9aYCOGHA.916@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I've just started dabbling with SQL Express (I've an up-coming project and
> would like to use it). I had no hassles connecting to the db I created in
> VS2005 std but now I want to test connectin to it outside of the inetpub.
> I
> copied the MDF and LDF to another folder on my drive and changed the conn
> string to reflect this but I get the following error:
> The header for file 'w:\temp\Test.mdf' is not a valid database file
> header.
> The PageAudit property is incorrect.
> An attempt to attach an auto-named database for file w:\temp\Test.mdf
> failed. A database with the same name exists, or specified file cannot be
> opened, or it is located on UNC share.
> Clearly something's gone wrong here but what would I need to do to fix
> this
> problem (and be able to connect to SQL Express db's from other folders in
> future)?
> Regards
> John.
>
>