Get information about a saved trace (Transact-SQL)
Applies to: SQL Server
This article describes how to use built-in functions to view a saved trace.
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Events instead.
View a specific trace
Execute
sys.fn_trace_getinfo
by specifying the ID of the trace about which information is needed. This function returns a table that lists the trace, trace property, and information about the property.Invoke the function this way:
SELECT * FROM ::fn_trace_getinfo(trace_id);
View all existing traces
Execute
sys.fn_trace_getinfo
by specifying0
ordefault
. This function returns a table that lists all the traces, their properties, and information about these properties.Invoke the function as follows:
SELECT * FROM ::fn_trace_getinfo(default);
.NET Framework security
Requires ALTER TRACE on the server.
See also
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru