>>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.

Thanks John, but we're updating tables from a commercial package and don't wish to change the structure or add stored procs since we might need to redo it after every upgrade. Any other solutions? We're consedring remote views...