>Well, the help states that @@ROWCOUNT should work, however, it returned 1 in a field (similar to how COUNT works) and when I tried to use rollback (because @@ROWCOUNT was > 0) it returned the ODBC Err# 3903, (1526) The Rollback transaction request has no corresponding BEGIN TRANSACTION. So why did it return 1 then?
because @@ROWCOUNT was > 0 (You meant TRANCOUNT, right)?
I'm not sure how ROWCOUNT corresponds to TRANCOUNT. As I said, trancount > 0 doesn't mean that it's your transaction opened, it just means you have opened transactions.
Check also
DBCC OPENTRAN
If it's not broken, fix it until it is.
My Blog