How to Display transactions happened in sqlserver 2005
-
Hi Recently i faced an issue on sql database. The database is in production which holds the data of all the employees in employee table Recently we found that values in employee table(not all values) got changed. Bdays, Status are the columns which we identified and not sure if there is more data that got modified. I need to find what exactly has happened, like any transactions that took place on the table? Or any other other way to find what has happened on database. Thanks in advance Naina
Naina
-
Hi Recently i faced an issue on sql database. The database is in production which holds the data of all the employees in employee table Recently we found that values in employee table(not all values) got changed. Bdays, Status are the columns which we identified and not sure if there is more data that got modified. I need to find what exactly has happened, like any transactions that took place on the table? Or any other other way to find what has happened on database. Thanks in advance Naina
Naina
You could check list of recently ran query in SQL. See HERE[^].
Regards, Hiren.
My Recent Article: - Way to know which control have raised PostBack
My Recent Tip/Trick: - Remove HTML Tag, get plain Text -
You could check list of recently ran query in SQL. See HERE[^].
Regards, Hiren.
My Recent Article: - Way to know which control have raised PostBack
My Recent Tip/Trick: - Remove HTML Tag, get plain TextHi Thanks for the query, but the query gives only today's transactions. Is there any way to get old transactions? Naina
Naina