Subject: Interesting problem with MSSQL transactions and PHP - msg#00000

I've spent the latter half of the afternoon trying to determine a
problem I've been having involving transactions and php. For some
reason whenever I start a transaction and close a transaction, the very
next query is always failing on me.



For example:



$query = '

begin transaction

select * from employees

commit';

$result = mssql_query($query);



$query2 = 'select * from employees';

$result2 = mssql_query($query2);

$result2 = mssql_query($query2);





The second query in the above code will fail every time but the second
time it's passed it will return a result properly. Is there something
I'm missing here for cleanup? I've tried using sleep() after the first
query thinking maybe the server needs to do some catching up for some
reason, but that doesn't seem to matter. Has anyone had a similar
experience or am I losing my mind?