HI THARVES,

I EXECUTED THE SCRIPT YOU GAVE TO FIND ANY GIVEN TABLE ALONG WITH THE DB NAME. I WONDER IF THAT SCRIPT WILL WORK ONLY IN 2005 OR 2000 ALSO...

HI ALL,

I FOUND HOW TO VIEW JOB FAILURE. SIMPLE GO TO THE FAILED JOB CLICK VIEW JOB HISTORY, CLICK THE SHOW STEP DETAILS CHECK BOX TO SEE A DETAILED REPORT....

HI,

in sql server log the job failure is displayed clearly.