I created a SQL Server Error Log Alert to find the word 'Fail' in the error logs. Mostly this alerts me to backup failures and login failures. Works well for my SQL 2005 thru 2008 R2 servers. For most or all of our SQL 2012 and SQL 2014 servers this alert is Broken, we get the following error - Error executing extended stored procedure: Invalid Parameter Type. We use DPA version 9.0.147. How do I make this work for my more modern SQL versions?
This was a known bug in 9.0.X of DPA. There was a change in the parameter type for that sproc that wasn't caught. Any possibility to upgrade to 9.1 where this alert was fixed? Sorry for any inconvenience!
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.