I have attached 2 SQL profile logs. Both do the same thing they on was done on a php webpage the other directly on SQL Studio.
My issue is that the webpage call to procedure connection gets reset by command 'exec sp_reset_connection'.
To be specific Profiler3.txt is done from web page
Profiler4.txt done directly from SQL
The Webpage procedure call gets cut off before all the transactions can finish there are 2 more inserts that need to get done and that does not happen. Granted the primary procedure that the page calls a second procedure that ultimately calls a 3rd procedure that does the insert.
When I say I did this from SQL Server I did it using the same user account the webpage uses to enter data
Best if opened in Excel (Comma Delimited)
Files are very messing so here are the lines of interest to my process Profile3.txt are Line 6467 all the way to Line 6880 where you can see Connection reset.
Starts at 742 and line 1146 is where Similarities ends the Insert on line 1194 does not happen on Profile3.txt.
My apologies on how the Profile data is given I dont know of another way. If expert want me to post this data in a different fashion please advise and I will do so.
I did not post here but if some needs me to post PHP code as well, I will do so.
Please advise why you think connection is being killed in the middle or if I need to post more info thanks in advance