All in one query for tracking DB changes in SQL version

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Is there any feature in sql server 2012 or in any version , wherein I can track all DB activities(DDL and DML) and others in one single query with who has modified and from where and when?
I need hostname or IP adddress as well.

What I have tried:

I tried below features which has some limitations
SQL Audit(Unable to track IP)
Event(Unable to track DML operations)
Trace(Unable to track DML operations)
Please help

Posted 8-Oct-16 2:56am

Member 12782887

Updated 8-Oct-16 8:49am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2016-10-08T07:42:00

Solution 1

Although I haven't used it much, i think you can start your research with SQL Server Profiler-
https://msdn.microsoft.com/en-us/library/ms181091.aspx[^]

If you need much more details than all these then I think you need to look for third party tool.

Hope, it helps :)

Posted 8-Oct-16 7:42am

Suvendu Shekhar Giri

Member 12782887 · Answer 2 · 2016-10-08T08:49:00

Solution 2

I used trace files(which is profiler only but query not GUI) to get data but its not tracking select, insert and delete statements.
I know GUI gives you everything but i dont want to run GUI.

Posted 8-Oct-16 8:49am

Member 12782887