sql server 2005 数据库邮件 发送报错Query execution failed: Sqlcmd: Error: Microsoft SQL N
我用sql server 2005 发送数据库邮件,如下:
declare @sql nvarchar(max)
set @sql = 'select 1'
exec msdb..sp_send_dbmail @profile_name = 'dba_profile'
,@recipients = 'Hengwu.Xu@urgamer.com;anthony.choi@urgamer.com'
,@subject = 'sql server 2005 mail test'
,@body = 'hello mail'
,@body_format = 'TEXT'
,@execute_query_database = 'DB_ErrorReport'
-- ,@query = @sql
-- ,@attach_query_result_as_file = 1
--,@query_attachment_filename = 'a.csv'
不用@query参数时,可以发送。但是当使用@query参数时,第一次是可以发送的,但是当再运行是就报如下的错误:
Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 495
Query execution failed: Sqlcmd: Error: Microsoft SQL Native Client : Unspecified error.
怎么查也不知道什么原因,请各位大侠援手啊。坐等!!!!!!!!!!