Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  client side clr sp?

Author  Topic  Mar Starting Member 47 Posts Posted - 2011-01-06 : 11:58:09 We are trying to implement change tracking and we have a lot of tables to track. I created a sp that creates a trigger when a table is passed to it and also a table to track the changes that are made to the table. I can get the changes to the data, the machine they were made from but am unable to get the user. I created a clr sp that gets the user but I don't know if I can run it on the client. Is there any way to do that? If not then is there any way to get the the windows network logged on user where the command originated from? I've tried CURRENT_USER, SESSION_USER, SUSER_ID, SUSER_SID, SUSER_SNAME, ORIGINAL_LOGIN, SYSTEM_USER, SUSER_NAME, USER_ID and USER_NAME but none of them do what I need. Is this impossible?