This solution did not work for me on SQL2008. Did the process change for 2008? On the restored database I still get the following error when trying to...

How about this simple solution:

http://blog.tylerholmes.com/2007/12/walkthrough-connecting-to-excel-2007.html

I just think that anyone who tries to use Dynamic SQL in a trigger is asking for trouble....

One issue that the "Trigger" solution does not address is how to deal with web or multi-tier applications.  In most cases the suser_sname will be the credentials of the middle tier...

I was torn between A and B also, both work in my parser and both are in options in the documentation.  But to be honest with you, neither are good...