Hi Rodolfo
>If I understand you, you mean I have to declare SQLEXEC("SET IMPLICIT_TRANSACTIONS OFF") and when I will update more than one record (or table) I have to do SQLEXEC("BEGIN TRANSACTION")... isn't it?
Sorry I must have been less than clear. Unless you set IMPLICIT_TRANSACTIONS off, there is no need to use an explicit BEGIN TRANSACTION. SQL Server will start the transaction. You DO, however, need to close the transaction explicitly, with either Commit or Rollback.
Is it the fastest way? Yes. Unless you take control of ending the transaction yourself, you will not be able to include multiple update statements in the same transaction (if SQL Server is in 'fully automatic' mode all it can possibly do is to treat each incoming update statement as a new transaction).
----
Regards
Andy Kramek