Can we increase @query_result_width (size) when using MSDB.DBO.SP_SEND_DBMAIL (stored procedure)

• vishal_mca2005

  Old Hand

  Points: 309

  More actions

  May 12, 2011 at 8:26 am

  #389513

  Hello All,

  I am getting problem when i am getting result of my user defined stored procedure

  I am using MSDB.DBO.SP_SEND_DBMAIL (stored procedure) to use send mail but the result set is exceeding 2 MB limit & I am getting below error.

  Msg 22050, Level 16, State 1, Line 0

  File attachment or query results size exceeds allowable value of 2097152 bytes.

  Please help me

  Thanks in advance

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  May 12, 2011 at 10:06 am

  #1323792

  Google is your friend.

  http://stackoverflow.com/questions/997628/how-do-i-increase-the-maximum-allowed-attachment-size-for-email-sent-using-msdb-d

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato