> You can't split a transaction between multiple calls to mssql_query. The
> memory used (in the server and client) are cleared between each call.
> You would have to create a batch of statements and execute these with one
> call to mssql_query.
No, I found solution in the end!:
SET XACT_ABORT OFF
It should be by default OFF and it is when I connect using Query
Analyser, but when I connect using PHP, it is ON.
I had to use
mssql_query("SET XACT_ABORT OFF");
and everything works as I expected.
--
\|||/
Prevít (. .) (já) <mailto:prvt@centrum.cz>
--==-o00o-(_)-o00o-==-----------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
