tracker issue : CF-3044053

select a category, or use search below
(searches all categories and all time range)

Bug 87127:-(Watson Migration Closure)Client Variables continually prepare and unprepare statements when using SQL Server

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/LowImpact

Reporter/Name(from Bugbase): Nathan Strutz / Nathan Strutz (Nathan Strutz)

Created: 10/07/2011

Components: General Server

Versions: 9.0.1

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Platforms All

Vote Count: 1


Client Variables continually prepare and unprepare statements when using SQL Server. This is visible with SQL Server Profiler. Every client variable retrieval and update executes sp_prepare, then the statement, then sp_unprepare. I have seen this on SQL Server 2000 and 2005.

Connect a SQL Server database as the client storage mechanism. Write a small application that makes use of the client scope. Monitor the queries going to the client storage database when using the application.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3044053

External Customer Info:
External Company:  
External Customer Name: Nathan Strutz
External Customer Email: 36EC2AB9446105B39920157F
External Test Config: 10/07/2011



This is daft. Should be fixed. -- Adam
Vote by External U.
20918 | October 11, 2012 04:35:13 AM GMT