# ====================================================================================================
# 
# NAME: MonitorErrorLog.ps1
# 
# AUTHOR: Yan Pan
# DATE  : 10/20/2007
# 
# COMMENT: This script captures errors from the SQL Server error log.
# =====================================================================================================

$query = "SELECT * FROM ERRORLOG"
$sqlnamespace = "root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER"
$selections= "LoginSid","PostTime","SQLInstance","IsSystem","DatabaseID", `
"ComputerName","SessionLoginName","SPID","TransactionID","EventSequence", `
"HostName","ClientProcessID","NTUserName","RequestID","DatabaseName", `
"Error","Severity","TextData","NTDomainName","LoginName","StartTime","ApplicationName"

Get-WMIEvent $query $sqlnamespace $selections