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

http://www.vandeputte.org/2006/11/sql-server-logon-triggers-part-2.html

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...