2 thoughts on “SQL Server – Mail – Error Message – “Error formatting query, probably invalid parameters [SQLSTATE 42000] (Error 22050). The step failed”

  1. Hi Daniel – I have been beating my head against a brick wall with this same oh-so-helpful error message. Have to say of all the google results I’ve been reading, your’s is the most complete and easy to understand. My issue ended up being the SQL Agent service account not having sufficient permissions to all the databases involved in the stored procedure being executed (they went 4 levels deep).
    So thank you for a well-written post!
    Lori

    • Lori,

      Blessing and thanks.

      I forced myself to open up a couple of Microsoft Connect Items to see if Microsoft will go look at the source code and show deeper error messages.

      And, possibly augment the sparse documentation.

      Once again, thanks for not giving up. An, leaving a hearty comment!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s