• QA in this case was meanth for Query Analyser

    So when I run the sproc from query analyser, everythig works fine,

    If I schedule a sqlagent job the start when sqlagent starts, everything works fine,

    When I set the same sproc for startup proc, then the proc to get the registrykey fails

    For the moment the sqlagent job is scheduled to start whenever sqlagent starts (is autostarted on this box)  and this workaround has been accepted.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me