Hi,

What permission needs regular users to execute the SP?

I'm receiving error: "Invalid object name '##tmpHtml2'." with regular users and with users within the db_owner group.

The only way I can execute the query is when sa user.

Thanks.