var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: System Report
How can i generate automated response from the server which provides me whole weekly sysetem report which contains, system up time, errors, how many login attemps, IO information,
Please help me.
you want to roll your own? i think there are plenty of 3rd party tools for this stuff.
if you want to do your own thing, you could use xp_readerrorlog to parse the sql logs, that might be a start.
yes want to create own and need system uptime in hours, login attemps, success and failures count, and other system information.
also need weekly report so I have no clue how to generate that report!!
I did advise already. You can use xp_readerrorlog to parse the sql logs.