Hi,

Thanks for all the help guys - I think I've FINALLY got it worked out! Had to use a ridiculous amount of '''s, but I thought that was my problem...

Hi All,

Thanks - I'll post the 'while' loop so you can see what I'm attempting to do 😉

WHILE (SELECT count(*) FROM #database_trigger_check WHERE processed = 0) != 0

BEGIN

SET @database_name =...

Hi All,

Ideally we want to be able to 'pick' what databases its installed on and automate it. There may be new user databases created that we dont want it enabled...

Hi,

If you mean using 'sys.syscomments' in SQL2005 - I have attempted to perform an update to the text field, however the result is:

Msg 259, Level 16, State 1, Line 1

Ad...

Hi,

I didnt want to disable the thresholds - just "group" them - which is precisely what I did and it worked! I created a group, with dynamic members, query formula...

Thanks for the info about the async option - I will look into that further.

I am actually doing the sp_updatestats after hours - however it seems a few hours later...