Ask you manager about purchasing Lumigent Log Explorer.  It is not that expensive and you will be able to use it for all your tables with little performance issues.  You...

You mentioned before that the refresh of the stored procedure helped.  Try setting your stored procedure to compile every time you run it. 

Are you running the stored procedure with the same arguments and the same login for both you application and query analyzer?  Did you copy exactly what was returned from the...