SSMS Log File Viewer - Filter option

When in SQL Server Management Studio, I can open Log file viewer to see
the SQL Server Errorlog, SQL Agent Log, etc. This applies to the 2005,
2008 or 2008 R2 versions.

I know there is the Filter option so that I can limit the entries I see
to something in particular. Is there a way to Filter OUT entries? An
example of what I mean would be that I want to see everything in the
Errorlog EXCEPT all the Backup entries. Can I do that?

I've looked in BOL and done web searches but haven't been able to find
anything useful that deals with the Filter option.

Thank you,
Toni

*** Sent via Developersdex http://www.developersdex.com ***

Toni (teibner@allinadotcom) writes:
> When in SQL Server Management Studio, I can open Log file viewer to see
> the SQL Server Errorlog, SQL Agent Log, etc. This applies to the 2005,
> 2008 or 2008 R2 versions.
>
> I know there is the Filter option so that I can limit the entries I see
> to something in particular. Is there a way to Filter OUT entries? An
> example of what I mean would be that I want to see everything in the
> Errorlog EXCEPT all the Backup entries. Can I do that?
>
> I've looked in BOL and done web searches but haven't been able to find
> anything useful that deals with the Filter option.

I am not aware of any such option, however, there is another possible
solution:
http://sqlblog.com/blogs/andrew_kelly/archive/2007/10/29/successful-ba...p-messa


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx