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 this in T-sql like an SP or a job etc..
please let me know if there is a better solution to track and send an email on analysis services.(I have 100's of cubes, so i cant enable error configuration on each cube.)
December 2, 2008 9:27 AM
December 2, 2008 2:16 PM