I have PHP web page that calls a stored procedure in SQL 2012 as UserA. The procedure does not complete.
When I run the same stored procedure from SSMS with same values as web as UserA the Stored Procedure completes normally.
As I move test and test the PHP calls to stored procedure completes intermittently.
what should I do.