Alan,

SQL Server 2005 SP2 CTP was released last week. MS added logon triggers. This will help you with problem.

See my follow up post on my blog

Yelena,

You are right, you can get the same results by running a trace and saving it to a table. However I think event notifications are more robust and...

The code below will do the trick with only one line of code:

EXEC master..xp_execresultset

N'SELECT ''GRANT EXEC ON '' + o.name + '' TO '' + ''my_user''

...

You're righth Robert.  Thanks for the tip.

I didn't like CopyFromRecordSet because I used to have lots of problems with it in earlier versions of Excel.  Now I managed to create...

Hi,

This is really a nice script.  I made a few changes.  Now it works with any SELECT statement or stored proc.

I posted the code on my blog:

http://users.telenet.be/frederik.vandeputte/blog/2005/07/anyquery2excelvbs.html

Kind...