SQLism

Logging and Blogging SQL Server Experiences.

Showing posts with label T-SQL. Show all posts
Showing posts with label T-SQL. Show all posts

Monday, August 13, 2012

T-SQL Script to load the trace file to a database table

T-SQL to load the trace file to a database table:


USE pubs
GO

SELECT *
INTO trace_table
FROM::fn_trace_gettable('c:\my_trace.trc', DEFAULT)
Posted by SQLism at 12:52 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: a, database, file, Load, Script, T-SQL, table, the, to, trace
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2020 (6)
    • ▼  July (1)
      • Reorganize all indexes in a Database in SQL Server.
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (9)
    • ►  September (1)
    • ►  August (6)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.