Our Client Side few people knows the sa user password. if they login through Management Studio and do some changes in data we will be the responsible for any
data lose. I wannted to monitor the User activities in SQL SERVER if Users login through Management studio.If sa users connected through Application I don't want to monitor it but, when user logged in through Management Studio and do some changes in SQL
We have to record the query fired by the user. is there any way to achieve this Please help me out.
Looking forward to hear from you
Thanks in advance
View Complete Post