A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Functions: System Functions

audit_event_name()

The system function audit_event_name() returns the description of an audit event. audit_event_name() is a Transact-SQL extension and can be executed by any user.

Syntax of the System Function audit_event_name()

    audit_event_name(audit_event_id)
    

The parameter of the System Function audit_event_name()

"audit_event_id"
The parameter "audit_event_id" is the number, i.e. the unique identifier of an audit event. The largest audit_event_id is 105, although there are only 100 adit events in total. Some audit_event_ids are set with NULL values. There are no logs kept for these audit events.

Example for the System Function audit_event_name()

    select audit_event_name(18)
    go

Returns the audit_event_name  Delete Table .

See also:
sp_audit,
Auditing,

See also:

ASE T-SQL - Aggregate Functions,
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().