• How is the query being run in the 2 environments,

    Is it a Sproc?

    Is it being executed by SSMS in both envinonments or is it bein executed by an application?

    fill in a couple of details about the execution context..

    cheers