This one is a little strange:
I have an SP that runs several time over a few hours in the same script. After about 3 hours, it has run 20 times or so, then I get a series of warnings: "mssql_execute(): stored procedure execution failed ..."
for the rest of the script.
So my script completes for only about half the data. It's not timing out or anything. Does a MsSQL connection get stale or something? I'm using
$conn = mssql_pconnect($database,$mssql_username,$password);
Should I be using
$conn = mssql_pconnect($database,$mssql_username,$password, true);
?
Thanks for your help!!