SET FMTONLY ON - Where does this come from

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » SET FMTONLY ON - Where does this come from

SET FMTONLY ON - Where does this come from

Rate Topic

Display Mode

Topic Options

Author

Message

nancy.lytle

Posted Friday, July 02, 2010 12:34 PM

Old Hand

Group: General Forum Members
Last Login: Friday, March 01, 2013 10:30 AM
Points: 366, Visits: 337

In 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 OFF

The 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?

Nancy

Post #947045

Bhuvnesh

Posted Tuesday, July 06, 2010 12:09 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Obviuosly a Sql code
http://technet.microsoft.com/en-us/library/ms173839.aspx

Google it to get more details

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #947715

nancy.lytle

Posted Tuesday, July 06, 2010 5:07 AM

Old Hand

Group: General Forum Members
Last Login: Friday, March 01, 2013 10:30 AM
Points: 366, Visits: 337

Thanks 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?

Nancy

Post #947817

dale.adams

Posted Wednesday, July 07, 2010 7:26 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 1:47 PM
Points: 746, Visits: 606

I solved a similar mystery by running a profiler trace to find where it was coming from. It was an SSIS package on another server.

Post #948522

TheSQLGuru

Posted Wednesday, July 07, 2010 7:28 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 3,582, Visits: 5,130

Lots 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! Smile

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #948525

greg 15422

Posted Thursday, November 29, 2012 2:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 26, 2013 6:59 AM
Points: 3, Visits: 15

I 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.

Post #1390864

« Prev Topic | Next Topic »

Permissions