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)
Aathi
"Aathi" is my first post. :-)
Tamil word "aathi" means "first", "orgin" and "begining"
It is my first post :D
Tamil word "aathi" means "first", "orgin" and "begining"
It is my first post :D
