>Only this:
>if you, in a sp_xxx, return data with a SELECT and SET ANSI_PADDING OFF
>SQL don't remove trailing spaces;
>if, after, you chnge the sp_xxx,
>and put data into a temp table and return temp table,
>the result is different.

It's under your control. You can use RTRIM to get desired result.