Who change what in a database SQL 2012


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
ken hanseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony PerkinsCommented:
Unfortunately no one can do that at least not without knowing your schema.

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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.