Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server IMPLICIT_TRANSACTIONS problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00789077
Message ID:
00789347
Vues:
20
Nelson,
Set implicit transactions is generally a call made by whatever client you are using. ADO does this automatically whenever you do a oConn.BeginTrans(). My guess is that the remote views you are using are doing this. It should be pretty easy to check

1. Create an updateable remote view.

2. Turn your profiler/trace on and
3. Make an update
4. See what gets sent to SQL Server.
5. I dont think that you will be able to turn this particular "feature" off.

Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform