I am in search of a tool which can give me the status of the activities performed in the SQL Server 2008 R@ environment. I want to know that which all users have logged in and which have failed login while accessing the SQL Server. I also want to get the details of the changes done through DDL commands in the SQL environment.

Thanks

tarun pant (tarun777.pant@gmail.com) writes:
> I am in search of a tool which can give me the status of the activities
> performed in the SQL Server 2008 R@ environment. I want to know that
> which all users have logged in and which have failed login while
> accessing the SQL Server. I also want to get the details of the changes
> done through DDL commands in the SQL environment. 

This is one option: http://www.apexsql.com/sql_tools_audit.aspx


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Hi Earland,

Thanks for your response. Just also wanted to know that is there any manual method through which we can solve these queries. Also can you let us know that are there any other tools also which are cost effective and can solve this query of mine.

Any help is highly appreciable.

Thanks

Hi Tarun,

For getting the details for all the user who have logged in and who have failed login while accessing the SQL Server, I can suggest you to go in for Lepide's tool. To get the details of the changes done through DDL commands also it is highly effective. For more details refer to http://www.sqlserveraudit.org/

 tarun pant wrote on 07/19/2013 05:32 ET :
> I am in search of a tool which can give me the status of the activities
> performed in the SQL Server 2008 R@ environment. I want to know that which all
> users have logged in and which have failed login while accessing the SQL
> Server. I also want to get the details of the changes done through DDL
commands
> in the SQL environment.
> 
> Thanks
> 
 I would suggest you to sql server audit tool (http://www.sqlserveraudit.org)
 which audits sql server changes and capture and store the entire data changes
 into a centralized repository. This utility provides facilitate to track the
sql
 server changes as who, what, when and where changes were made and allows to
 automate the report generation .