Sigma rule: MSSQL Destructive Query

Rule

Title

MSSQL Destructive Query

Status

experimental

Level

medium

Author

Daniel Degasperi '@d4ns4n_'

Date

2025-06-04

File

rules/windows/builtin/application/mssqlserver/win_mssql_destructive_query.yml

Commit

ccbb0369507f796db0b0ae6854c8a2be471b9d84

Detects the invocation of MS SQL transactions that are destructive towards table or database data, such as "DROP TABLE" or "DROP DATABASE".

Log source

product

windows

service

application

definition

Requirements: MSSQL audit policy must be enabled in order to receive this event (event id 33205)

Detection

selection:
    Provider_Name: 'MSSQLSERVER$AUDIT'
    EventID: 33205
    Data|contains:
        - 'statement:TRUNCATE TABLE'
        - 'statement:DROP TABLE'
        - 'statement:DROP DATABASE'
condition: selection

False positives (as the rule lists them)

• Legitimate transaction from a sysadmin.

Tags

• attack.exfiltration
• attack.impact
• attack.t1485

MITRE ATT&CK ids this rule names

• T1485

References

• https://learn.microsoft.com/en-us/sql/t-sql/statements/drop-table-transact-sql?view=sql-server-ver16
• https://learn.microsoft.com/en-us/sql/t-sql/statements/drop-database-transact-sql?view=sql-server-ver16
• https://learn.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver16

Read on 2026-11-03T00:58:21.399Z under licence sigma-drl-1.1@d5f4c36a from https://github.com/SigmaHQ/sigma/blob/ccbb0369507f796db0b0ae6854c8a2be471b9d84/rules/windows/builtin/application/mssqlserver/win_mssql_destructive_query.yml