Who is the DBO? 1

[LonnieJohnson]

I have a situation where I have a trigger that stores the user_name in field when an update is done. The problem is that we have two people who are considered dbo whom may also change data in the tables (small company). Thus no matter what I use (USER, USER_NAME, SESSION_NAME), they all say dbo instead of who the user actually is. What function or method do I use to determine which dbo this is?

As usual, thanks in advance for any help you can throw my way.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[SQLSister]

YOu can try System_User that got it for me when I experimented, but it has my domain included too, so you may need a longer field size!

 

[LonnieJohnson]

Oh yeah SQL Sister, that did it! You da bomb. I don't know how I missed that one, but I'm glad you responded.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[SQLSister]

As it happened, I learned something new in looking for the answer to your problem. Hadn't noticed that before myself.

 

[MaffewW]

BTW that is the user who is logged on to SQL Server, not necessarily the user who is logged on to the machine (unless your using NT authentication) but it sounds like what you are after

Matt

Brighton, UK