Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    319

    Arrow Unanswered: any idea what generates this SQL?

    I have been running a trace for the past few weeks and I have started to look at what is being captured. This query was running for 180 minutes and I am trying to figure out what the source could be. What formats SQL code this way when captured via a Profiler trace? I have renamed the column, db and table names.

    declare @p1 int set @p1=1 exec sp_prepexec @p1 output,NULL
    ,N'SELECT
    "Tbl1006"."privateColumn1" "Col1074"
    , "Tbl1006"."privateColumn2" "Col1075"
    , "Tbl1006"."privateColumn3" "Col1076"
    , "Tbl1006"."privateColumn4" "Col1077"
    , "Tbl1006"."privateColumn5" "Col1078"
    , "Tbl1006"."privateColumn6" "Col1079"
    , "Tbl1006"."privateColumn7" "Col1080"
    , "Tbl1006"."privateColumn8" "Col1081"
    , "Tbl1006"."privateColumn9" "Col1082"
    , "Tbl1006"."privateColumn10" "Col1083"
    , "Tbl1006"."privateColumn11" "Col1084"
    , "Tbl1006"."privateColumn12" "Col1085"
    , "Tbl1006"."privateColumn13" "Col1086"
    , "Tbl1006"."privateColumn14" "Col1087"
    FROM
    "privateDB"."dbo"."privateTableName" "Tbl1006"
    ORDER BY
    "Col1076" ASC
    , "Col1077" ASC
    , "Col1078" ASC
    , "Col1085" ASC'
    select @p1

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Never mind....
    Last edited by corncrowe; 01-26-11 at 05:51.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •