ken hanse
asked on
Who change what in a database SQL 2012
Hi,
Can some one post a script that can put into a Database, where by it generate a report to find out what changes happened daily basis.
May trigger, or any report to me see daily to manage my environment. this is because we are working in team, as a manager I need to see what changes happened on the data base.
thanks in advance
Can some one post a script that can put into a Database, where by it generate a report to find out what changes happened daily basis.
May trigger, or any report to me see daily to manage my environment. this is because we are working in team, as a manager I need to see what changes happened on the data base.
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are some few solutions that you can apply to your environment depending on what you want.
As mentioned above, without more information we can't help you. Your question is very generic.
As mentioned above, without more information we can't help you. Your question is very generic.
What we can do is ask you for more information about your system and what you are trying to achieve. Is it the Who, what, and when that you need. If so depending on your SQL Server version and edition it may be possible with minimal coding. Otherwise you are looking at building triggers for all your tables with the appropriate code to log the results. If you also want to know what was viewed, by who and when then it is more complicated.