Is it possible to create custom alerts to monitor specific SQL messages? like DML or DDL statements?
Once you make an alert above it should have a preset set it to objects and find your SQL object and then continue to make the alert like any other. This should add a limitation like if it was a view.
http://www.solarwinds.com/documentation/Orion/docs/UnderstandingOrionAdvancedAlerts.pdf
May help you, smart to print these things out for easy lookup, keep them in a binder as an admin manual near where you are working.
It sounds like you want something akin to an auditing feature (since you mention DML and DDL). If that's what you are looking for, then I would suggest you use SQL Server Audit (assuming you are running version 2008+). You can capture DDL and DML statements as needed, output them to a file, and then use a tool like LEM for alerts.
DPA is not going to be the right tool for alerting on DDL and DML statements. You could certainly use DPA to alert on things written to the error logs, but that would mean you would have to spend time writing code. SQL Server Audit would do a lot of that coding for you.
HTH
