Results 1 to 2 of 2

Thread: commit transaction between sql2000 and sql2005 server

  1. 10-20-2006, 10:40 AM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    commit transaction between sql2000 and sql2005 server

    Are there any tips/techniques/issues when doing a begin tran and commit between a sql 2000 server/db and a sql 2005 server/db. Should you still use "set xact_abort on"? This will be a recordset of about 1-2000
    Reply With Quote Reply With Quote
  2. 11-02-2006, 08:59 PM #2
    ravinder_k
    ravinder_k is offline Registered User
    Join Date
    Feb 2003
    Posts
    34
    both versions behaved same way. use it if you want to maintain ATOMICITY in the transaction.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules