Thanks for that Bob. The only slight issue being that the overall job run_time doesn't always equal the step run_time ie the step can be 1min + longer.

Thanks for your input both. The scripts look great but I'm keen to understand the underlying cause too. I'm not getting any errors and have even traced it...

ok thanks for that Paul. I guess i'll need to set up some jobs on a separate server but run them against this one. Thanks again.

Hi, thanks for the response.

1) yes there is

2) it does the same with or without quotes ie fail the syntax check. It checks ok syntacically if I remove the where...

Thanks for that Lowell, looks like just what I was after!

However when I go to onstall it immediately errors at 0% with no info. I'll chat to our Windows...

Thanks, all good points. The table I'm placing the trigger on though is a password table that an app uses, its seldomly accessed, but I want to alert myself...

Hi, did you get this working as I have the same issue. Was DB chaining the solution? See properties --> options of DB, then "Cross DB ownership chaining enabled",...

Have now found and amended this. The settings should all have been False, one was true. I changed them all to true (as the report was expecting)....BUT it...

Thanks, tried that, but now when i preview I get the error....'the tablix has an invaled tablixmember. It must have the same value set for the RepeatOnNewPage property as those...

Thanks again for your help with this. It seems as I've only got a trial version the button is greyed out. I can't get to it with an...

Have downloaded v10 now so can see the option. Hoever it now only seems to compare tables and users, no other objects !?!?

Thanks for your help with this, I'd love to get it working. However I dont see that 'option' 🙁 Only an option to 'add with encryption' ...

Just tried Redagte on a 2005 DB and it tells me its encrypted!!?

Hi, thanks for your help on this.

Your code didnt quite work as expected (select returned 0 rows), but as mentioned I'd already tried that to give exactly the same error....

That is exactly it Lowell!! Thanks so much for your time on this, it works a treat and saves me time re-working other solutions 🙂