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 2, 2010 12:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, July 20, 2014 5:58 PM
Points: 386, Visits: 386
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 6, 2010 12:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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 6, 2010 5:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, July 20, 2014 5:58 PM
Points: 386, Visits: 386
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 7, 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 5, 2014 6:48 AM
Points: 747, 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 7, 2010 7:28 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 4,319, Visits: 6,112
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: Wednesday, April 30, 2014 10:29 AM
Points: 3, Visits: 24
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