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
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