HI All,
We are building a application for users to make changes to the DB so we are building in some audit functionality to record who is doing what. The guy that is doing the application has been away so i was wondering whether there was any way that i can capture the log in information from SQL.
ideally the Pc name, IP address or windows log in would be excellent. Just so we have some come back if someone screws up the DB!
Thanks in advance for your help
We are building a application for users to make changes to the DB so we are building in some audit functionality to record who is doing what. The guy that is doing the application has been away so i was wondering whether there was any way that i can capture the log in information from SQL.
ideally the Pc name, IP address or windows log in would be excellent. Just so we have some come back if someone screws up the DB!
Thanks in advance for your help