Hello, I'm using xp_sendmail in SQL 2005 and received this error
"xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
@.ansi_attachment no longer supported in 2005
Sample Below
Select @.SQLQuery = 'Declare @.rc int
EXEC @.rc = master.dbo.xp_sendmail
@.recipients = N'''+@.vTo+'''
,@.message = N'''+@.vMessage+'''
,@.query = N'''+@.vSQL+'''
,@.attachments =''Prices Expiring.txt''
,@.ansi_attachment=''TRUE''
,@.copy_recipients = N'''+@.vCC+'''
,@.subject = N'''+@.vSubject+'''
,@.attach_results = ''TRUE''
,@.width = 500I see this article but, since I do not see any mention of the parameter in
either 2000 or 2005 Books Online, I imagine this was only a temporary fix.
Is there any reason you would ever want to set the value to false? If not,
then my suggestion is to check the registry value (I can't imagine it would
default to false). Support will probably steer you towards database mail in
2005, as opposed to SQL Mail, anyway...
A
"Don" <Don@.discussions.microsoft.com> wrote in message
news:6362A1E7-524F-46C3-912D-ABBCCCA5A6DB@.microsoft.com...
> Hello, I'm using xp_sendmail in SQL 2005 and received this error
> "xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
> @.ansi_attachment no longer supported in 2005
> Sample Below
> Select @.SQLQuery = 'Declare @.rc int
> EXEC @.rc = master.dbo.xp_sendmail
> @.recipients = N'''+@.vTo+'''
> ,@.message = N'''+@.vMessage+'''
> ,@.query = N'''+@.vSQL+'''
> ,@.attachments =''Prices Expiring.txt''
> ,@.ansi_attachment=''TRUE''
> ,@.copy_recipients = N'''+@.vCC+'''
> ,@.subject = N'''+@.vSubject+'''
> ,@.attach_results = ''TRUE''
> ,@.width = 500
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment