SQLServerCentral / SQL Server 2005 / SQL Server 2005 Performance Tuning / SET FMTONLY ON - Where does this come from / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:52:30 GMT20RE: SET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxI can tell you that SSIS packages can generate code that looks very similar to what you are asking about. If you have SSIS in your environment, Id start with those folks. Thu, 29 Nov 2012 14:27:30 GMTgreg 15422RE: SET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxLots of things like ADOc, ORMs, autogenerate code, SSIS, etc gather information about recordsets and other metadata under the covers. I recommend you use various columns in sysprocesses or the replacement DMVs and also Profiler to capture information about what user, machine, application, etc is making these calls. Then you can go give them the what for, how come and why not! :-)Wed, 07 Jul 2010 07:28:57 GMTTheSQLGuruRE: SET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxI solved a similar mystery by running a profiler trace to find where it was coming from. It was an SSIS package on another server.Wed, 07 Jul 2010 07:26:15 GMTdale.adamsRE: SET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxThanks for responding. It is obviously SQL code, the problem is I cannot figure out who/what is call that particular code. It is not in any SQL script for the application. Could it be called by an internal SQL process or by an ODBC driver?NancyTue, 06 Jul 2010 05:07:27 GMTnancy.lytleRE: SET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxObviuosly a Sql code [url]http://technet.microsoft.com/en-us/library/ms173839.aspx[/url]Google it to get more detailsTue, 06 Jul 2010 00:09:29 GMTBhuvneshSET FMTONLY ON - Where does this come fromhttp://www.sqlservercentral.com/Forums/Topic947045-360-1.aspxIn doing monitoring and troubleshooting I have found a lot of the following statement as lead blockers in on and off blocking on a production server:SET FMTONLY ON select CONSTRAINT_NAME, CONSTRAINT_CATALOG from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where 1=2 SET FMTONLY OFFThe problem is I can't seem to find where this statement is coming from, it is not is the Perl code that we use, or any of the SQL scripts.Anyone have any ideas?NancyFri, 02 Jul 2010 12:34:25 GMTnancy.lytle