>Hi all,
>
>I want to know if an UPDATE or a DELETE worked or not using SPT. SQLEXEC() returns 1 but I don't know if the command worked or not.
>
>TIA


The most robust (and technically the best way) to handle this is to create a stored procedure - which will encapsulate the transaction and exception handling. Your proc can populate an output variable that will hold a status status code.

Subsequent calls to @@rowcount are not reliable. Also, it requires a second call - which is not optimal by any means.