Hi Experts, Since, we know that severity-16 alerts includes the database mirroring connection related errors and we are getting database mirroring errors a lot due to network fluctuation. Is there a way that we can only disable the mirroring related severity errors and exclude it from severity-16 and other errors will work as it is. I know we should work toward the network area but if we have anything to do in SQL. Please help. Thanks, Neeraj
You do not say what version of SQL Server you are working with. On SQL Server 2014 and above I use the following code: EXECUTE sp_altermessage , 'WITH_LOG', 'true'; GO To turn off the logging, change the true to a false.