When using transactions with an odbc connection; to ensure that operations on the remote server are rolled back in the event of an error do you put the begintrans statement before or after you connect to the remote server?

Cheers,

Brian