# ====================================================================================================
# 
# NAME: MonitorDatabases.ps1
# 
# AUTHOR: Yan Pan
# DATE  : 11/6/2007
# 
# COMMENT: This script monitors database changes.
# =====================================================================================================

$query = "SELECT * FROM DDL_SERVER_LEVEL_EVENTS `
WHERE __CLASS = 'CREATE_DATABASE' or __CLASS = 'ALTER_DATABASE' `
or __CLASS = 'DROP_DATABASE'"
$sqlnamespace = "root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER"
$selections= "SQLInstance","PostTime","ComputerName","SPID","LoginName", `
"TSQLCommand","DatabaseName"

Get-WMIEvent $query $sqlnamespace $selections