Reports the name of the device that contains the first page of the transaction log.
sp_helplog
Reports “master” as the name of the device:
sp_helplog
In database 'master', the log starts on device 'master'.
sp_helplog displays the name of the device that contains the first page of the transaction log in the current database.
Any user can execute sp_helplog. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Commands alter database, create database
System procedures sp_helpdevice, sp_logdevice
