Click here to Skip to main content
15,314,594 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi guys,

In sql.

i have a table, i inserted few rows, now, some one edited some values in this table,
the value was edited directly in table using 'Edit top 200 rows'.

i want to know, is there any way,to get info'n that any value was edited.

plz let me know.


What I have tried:

will triggers work here?

to get the info'n that so n so value was edited.
Updated 29-Mar-16 3:23am
Mohibur Rashid 29-Mar-16 9:06am
Good question. Look for history

1 solution

If you are using the Enterprise version then you can enable the Auditing feature - SQL Server 2008 Auditing Feature[^]

There is also Change Tracking - Tracking Data Changes[^]

If you do not have these features on your version then you could use triggers - example here Auditing with Triggers[^]
abdul subhan mohammed 30-Mar-16 4:30am
But dude, i have a published server.
CHill60 30-Mar-16 10:05am
I don't understand this comment

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900