MSQL Auditing
Hello.
I'm dot.net developer, and i'm working a lot with MSQL. My current task is when some user executes select query on database, i should "catch" the query data. What do i mean is if select query is "select * from UsersTbl where UserID = 5", i have to get '5'. Does somebody have any idea where to start???
Thanks a lot.
Dmitry
Software/Hardware used:
I'm dot.net developer, and i'm working a lot with MSQL. My current task is when some user executes select query on database, i should "catch" the query data. What do i mean is if select query is "select * from UsersTbl where UserID = 5", i have to get '5'. Does somebody have any idea where to start???
Thanks a lot.
Dmitry
Software/Hardware used:
ASKED:
September 27, 2010 8:25 AM
UPDATED:
April 9, 2011 11:58 AM
Answer Wiki:
if the database is in u r server then u can select the data which u have given. we can select the data with unique key column id in table we have give max id for particular column
from then we can select the data as u r required from FIFO method
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
