Thanks again for the very useful replies. I am currently implementing the Notification services option on my management server. The reason I chose this instead of traces, is that I now do not need to create directories and organize access on the file systems of all servers. (Our servers are unfortunately not standardized and I therefore have to do this manually on many of the 50 servers!)

AndI thank you so much for the scripts Colleen. It saved me a lot of googling and BOL-ing! I do have one more question about the CREATE QUEUE statement. From BOL I understand that ‘EXECUTE AS SELF’ means that the sp will be executed with privileges of the user who created the queue. If this is me, does itt mean that this will cause a problem when I leave the company and my AD account gets deleted? If so, what then is best practice, keeping in mind that some servers run under Local System account and others under AD startup accounts.