SQL Server 2005 System Report
I need some ideas of how to create a SQL Server System Report, i.e. how much memory has been consumed, how much time was taken in a job run? Can some one provide me an example, please? Thanx.

Answer Question   |  May 15, 2010  4:40 PM
SQL Server 2005 administration, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services

How to enable a trace for SQL Server Analysis Services using T-SQL?
Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do [...]

Answer Question   |  December 2, 2008  9:27 AM
SQL Profiler, SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server administration, SQL Server Analysis Services, SSAS, SSAS 2005, T-SQL