Geek Answers Handbook

ColdFusion executing unwanted SQL statements

I have an application that downloads a huge amount of data from twitter. We started to notice some performance issues, so I am setting up SQL Profiler for the application database. I noticed that the following SQL statement is executing, but not showing up anywhere in my code. Therefore, I assume that SQL Server 2005 or ColdFusion 8 for some reason adds these statements.

  • SET TRANSACTION ISOLATION LEVEL READ COMMITTED
  • SET FMTONLY ON select Title from Links where 1=2 SET FMTONLY OFF
  • exec [sys].sp_datatype_info_90 -9,@ODBCVer=4
  • EXEC sp_executesql N'set implicit_transactions off select USER_NAME() select usertype,type,name from systypes where usertype>=257'
  • EXEC sp_execute 16,'iTunes Store'
  • exec sp_unprepare 28
  • I have no cftransaction in my code
  • All my queries are launched from cfqueries. (no stored procedures)
  • I never run an execute or exec statement anywhere in my code
  • All of these statements are run from my database user account, which is specifically configured for my web application.
  • # 5 # 6
  • # 5

, , , ?

+5
2

, , .

- , , / .

. VB6, , () sp_cursor, , - , ADO .

, -

+2

More articles:


All Articles