Monday, May 30, 2005
Useful trace function
A T-SQL function which I came across today is ::fn_trace_gettable.
I've came to know this function from http://groups.yahoo.com/group/sqlcon/
This function displays trace file information in a table format.
Syntax:
fn_trace_gettable( [ @filename = ] filename , [ @numfiles = ] number_files )
Example:
SELECT * FROM ::fn_trace_gettable('c:\my_trace.trc', default)
I've came to know this function from http://groups.yahoo.com/group/sqlcon/
This function displays trace file information in a table format.
Syntax:
fn_trace_gettable( [ @filename = ] filename , [ @numfiles = ] number_files )
Example:
SELECT * FROM ::fn_trace_gettable('c:\my_trace.trc', default)
# posted by Satheesh Chandra @ 1:48 AM 
