SQL Server Audit Log Event ID 24042
24042: Issued a view database state command (action_id VDST)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
A command was issued to view the state of a database
Free Security Log Resources by Randy
| Field | Description |
|---|
| Occurred | When event was reported by SQL Server |
| Authorization result | If the command passed authorization checks |
| Session ID | ID of the session on which the event occurred |
| User | |
| Server | |
| Database | Database affected by the event |
| Statement | Transact-SQL statement |
Supercharger Free Edition
Your entire Windows Event Collection environment on a single pane of glass.
Free.
This Event Is Produced By
Which Integrates with Your SIEM
Issued a view database state command
A command was issued to view the state of a database
Action Group: DATABASE_OPERATION_GROUP
Occurred: 8/22/2013 6:09:46.0000000 PM
Authorization result: Access allowed
Session ID: 62
User: LB\dev4sqlc
Server: DEV3
Database: WSS_Logging
Statement: SELECT ; @ReservedBytes=SUM (reserved_page_count)*8*1024,; @UsedBytes =SUM (used_page_count)*8*1024; FROM ; sys.dm_db_partition_stats WITH (NOLOCK); WHERE ; object_id = object_id(@PartitionName); --Use UsedBytes if we are not close to fill the table.
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24042
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection