Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Commit/Rollback Question
Greetings,
I wanted to find if I could do this:
Begin Trans A
--Code
Begin Trans B
--Code
Commit Trans B
--Code
Rollback Trans A
The problem was we had some nested transactions, and wanted to find out if we could Commit one transaction, and Rollback around it. Apparently there was a setting in a previous version of SQL that would allow this, according to one of our DBA's, but 7.0 doesn't have the same functionality. At this point, we believe it can't be done, but I wanted to get wider input before going around this.
TIA,
Brad
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement