Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Know the Modifier's Login Expand / Collapse
Posted Saturday, August 17, 2013 10:38 PM


Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
I have done modifications in a table directly from Edit mode of SQL Server. Now is it possible to know the which login is used to done the modifications.

Please help me to know it.

Post #1485553
Posted Saturday, August 17, 2013 11:18 PM



Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 35,954, Visits: 30,243
You would need a trigger and, probably, the ORIGINAL_LOGIN() function to capture the login of the person making the direct changes.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1485556
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse