System views

Deprecated feature

Replacement

Feature name

syspermissions

sysprocesses

sysprotects

sysreferences

sysremotelogins

sysservers

systypes

sysusers

syspermissions

sysprocesses

sysprotects

sysreferences

sysremotelogins

sysservers

systypes

sysusers

None

numbered_procedures

numbered_procedure_parameters

Deprecated feature

Replacement

Feature name

fn_trace_geteventinfo

fn_trace_getfilterinfo

fn_trace_getinfo

fn_trace_gettable

sys.trace_categories

sys.trace_columns

sys.trace_subclass_values

Extended Events overview

fn_trace_geteventinfo

fn_trace_getfilterinfo

fn_trace_getinfo

fn_trace_gettable

SQL Trace stored procedures, functions, and catalog views

ﾉ

Expand table

ﾉ

Expand table

sys.numbered_procedures sys.numbered_procedure_parameters

sp_trace_create sp_trace_setevent sp_trace_setfilter sp_trace_setstatus

sys.traces sys.trace_events sys.trace_event_bindings

sp_trace_create sp_trace_setevent sp_trace_setfilter sp_trace_setstatus

sys.traces sys.trace_events sys.trace_event_bindings sys.trace_categories sys.trace_columns sys.trace_subclass_values