error message with sp_send_dbmail

good day,

When using the following code:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQL',
@recipients = 'sql@ccdcc.ca',
@body = 'The following Databases need your attention: ',
@query = 'Select * from dbo.##Tbl_CombinedInfo',
@subject = 'TESTING email feature from SQL 2005',
@attach_query_result_as_file = 0;

I get hte following error:
Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters

If i remove the @ querry variables and re-execute, it works fine.
Can anyone shead some light on why it would not work when i insert the
@query variable?

Thank you.

On Feb 10, 1:22 am, Patrick wrote:
> good day,
>
> When using the following code:
> EXEC msdb.dbo.sp_send_dbmail
> @profile_name = 'SQL',
> @recipients = '...@ccdcc.ca',
> @body = 'The following Databases need your attention: ',
> @query = 'Select * from dbo.##Tbl_CombinedInfo',
> @subject = 'TESTING email feature from SQL 2005',
> @attach_query_result_as_file = 0;
>
> I get hte following error:
> Msg 22050, Level 16, State 1, Line 0
> Error formatting query, probably invalid parameters
>
> If i remove the @ querry variables and re-execute, it works fine.
> Can anyone shead some light on why it would not work when i insert the
> @query variable?
>
> Thank you.

I am not getting any error while using @query parameter.
Are you sure that you have type name of temp table correctly?


Amish Shah
http://shahamishm.blogspot.com