Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server IMPLICIT_TRANSACTIONS problem
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00789077
Message ID:
00789347
Views:
21
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform