• thanks,

    if it was more than 1 statement I wouldn't expect to see it multiple times in profiler? (i.e because the statement was in a stored proc I actually used the Audit Schema Object event to monitor those statements.

    I am only seeing the statement once before the procedure ends.

    Currently I am monitoring in profiler looking for statements greater than 5 seconds to see when the procedure fires again and also monitoring for status changes in mirroring