I need to know the name of the user or the group that the current connection is connected with. I am using NT security and a SQL Server database for the connection. Is there anyway to get this information?

If this isn't clear let me know and I'll try to explain better...