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 |
|
TMDOSS
Starting Member
33 Posts |
 Posted - 2010-03-31 : 15:38:45
|
I need to create the trigger to Capture who is changing values in the Table.(User name and data) I think I need to user Isnerted table.Can u help  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-01 : 03:58:26
|
| This may help:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170215 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-01 : 05:04:31
|
| Inserted table will have only actual data you insert. for grabbing user name info use USER_NAME() or SYSEM_USER function------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
TMDOSS
Starting Member
33 Posts |
Posted - 2010-04-01 : 09:40:31
|
| It's 3rd Party Software.it uses Windows account to login |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-14 : 08:39:56
|
quote:
Originally posted by TMDOSS
It's 3rd Party Software.it uses Windows account to login
then SUSER_SNAME() should give the user in scope------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL Audit - finding Username with Triggers