How to determine if a transaction is still pending in SQ

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to determine if a transaction is still pending in SQ

Message

01/05/2007 10:43:32

Naomi Nosonovsky
Wisconsin, États-Unis

01/05/2007 10:20:15

Tc Holzer
Isle of Man

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: How to determine if a transaction is still pending in SQ

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01221475

Message ID:

01221489

Vues:

This message has been marked as the solution to the initial question of the thread.

>Connecting to SQLServer 2005, if a BEGIN TRANSACTION is sent to SQLServer, what is the safest way to determine if a ROLLBACK or COMMIT were or were not sent to end the transaction? If you send a COMMIT or ROLLBACK and no transaction is pending, you receive the SQL error...

Check SELECT @@trancount

If it's not broken, fix it until it is.

My Blog

Répondre

Fil

Voir

Click here to load this message in the networking platform