> 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!:
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:[EMAIL PROTECTED]>

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to