# ====================================================================================================
# 
# NAME: MonitorStoredProcs.ps1
# 
# AUTHOR: Yan Pan
# DATE  : 11/7/2007
# 
# COMMENT: This script monitors changes to stored procedures.
# =====================================================================================================

$query = "SELECT * FROM DDL_PROCEDURE_EVENTS WHERE DatabaseName='AdventureWorks'"
$sqlnamespace = "root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER"
$selections = "SchemaName","TSQLCommand","PostTime","SQLInstance","ObjectName", `
"ObjectType","DatabaseName","ComputerName","SPID","LoginName","UserName"

Get-WMIEvent $query $sqlnamespace $selections