Wednesday, July 10, 2013

6 Query default trace


List trace category and event name

SELECT te.category_id,,te.trace_event_id, FROM 
  sys.trace_events te,    sys.trace_categories tc
  WHERE te.category_id = tc.category_id



Query Default trace


FROM   ::fn_trace_gettable(CONVERT(VARCHAR(150), ( SELECT TOP 1 f.[value] FROM sys.fn_trace_getinfo(NULL) f WHERE = 2)), DEFAULT) AS ftg 
INNER   JOIN sys.trace_events AS te ON ftg.EventClass = te.trace_event_id  
INNER JOIN sys.trace_categories AS tc ON tc.category_id = te.category_id
ORDER BY   ftg.StartTime




SQL server trace:


  1. Cartierbuy replica watches is the renowned French jeweller and watchmaker with replica cartier a history of pioneering design and a drive for excellence. The first references to Cartier wristwatches date back to 1888. Late in the 19th century it was pocket and chatelaine watches that were most popular, but Louis Cartier saw a future in timepieces that could be worn on the wrist.

  2. Shop online for Moncler fake moncler jackets Clothing, Jackets & Coats fake moncler men jackets for Men and Women . Free Shipping & Free Returns for Loyallists or most Orders Over ...

  3. Very excellent post!!! Thank you so much for your great content. Keep posting.....

    Big Data Training Institute in Pune
    Hadoop Training in Pune


  4. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.

    Adding Exponents
    fiu canvas
    interval notation
    Area of a Hexagon



SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates