Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SET FMTONLY ON - Where does this come from Expand / Collapse
Author
Message
Posted Friday, July 02, 2010 12:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, April 06, 2014 2:31 PM
Points: 384, Visits: 357
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
Posted Tuesday, July 06, 2010 12:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
Obviuosly a Sql code
http://technet.microsoft.com/en-us/library/ms173839.aspx

Google it to get more details


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #947715
Posted Tuesday, July 06, 2010 5:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, April 06, 2014 2:31 PM
Points: 384, Visits: 357
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
Posted Wednesday, July 07, 2010 7:26 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 6:48 AM
Points: 746, Visits: 615
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
Posted Wednesday, July 07, 2010 7:28 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:43 PM
Points: 4,128, Visits: 5,836
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!

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #948525
Posted Thursday, November 29, 2012 2:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 2:15 PM
Points: 3, Visits: 23
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 »

Add to briefcase

Permissions Expand / Collapse