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.
| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2005-03-29 : 12:36:57
|
| Is there a way to know the user that updated last in the table or a particular column. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-29 : 12:46:32
|
| you need to add a trigger to your table and update a column after any update or INSERT to store information such as this.- Jeff |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-03-29 : 13:13:19
|
| Is there any system stored procedure or system table which will give the information |
|
|
|
andy8979
Starting Member
36 Posts |
Posted - 2005-03-29 : 13:49:39
|
As per my knowledge there is no system table which gives you the information regarding who inserted or updated the information in a table for this you will have to write your own logic. Andy8979 |
|
|
|
|
|
|
updated last by whom