MSSQL only allows one HRESULT open per connection. If you have a query with a server side cursor open any subsequent queries using that connection will fail.
mssql_free_result
Description
bool mssql_free_result ( resource result )mssql_free_result() only needs to be called if you are worried about using too much memory while your script is running. All result memory will automatically be freed when the script ends. You may call mssql_free_result() with the result identifier as an argument and the associated result memory will be freed.
add a note
User Contributed Notes
veggivore [at] yahoo [period] com
07-Sep-2006 12:21
07-Sep-2006 12:21
27-Jul-2005 05:56
Bug #33877 When multiple result sets are not freed subsequent queries fail