I have a strange issue. I have a very large memory driven stored procedure that does all the work in #tmp tables. Runs perfect from ssms, and .net query, but if I execute the procedure from php it never returns the correct results, it crashes during one of the inserts into #tmp??
I fixed by changing my #tmp table to a table variable, but this one has me confused. All options are set the same from what I can see. Any idea why there is a difference?