I'm troubleshooting a response time problem with an application that connects to a SQL Server 2000 database. One particular workstation has the problem of the following statements showing multiple times in the profiler:
SET NO_BROWSETABLE ON
SET NO_BROWSETABLE OFF
IF @@TRANCOUNT > 0 COMMIT TRAN
I'm at a loss how to fix this issue. I went to the Microsoft site and noticed there was an issue like this that was an MDAC issue in 2.1, 2.5. and 2.6. I'm at the latest version of 2.8 and it's still having a problem. Please help!!!