Track all logins on to a single SQL Server database -


Thanks in advance for any help.

We have a special database on a SQL Server 2012 box with about 20 other databases.

What do I need is a method / script / audit (open brain about solution) which just to track someone (successfully / unsuccessfully) because this is a special database server (single database key) The end user does not want information on any other database that sits on the server), it will also be time logging the attempt was made and it must be tracked through the SQL Server login or application which

Once we have this information that we need to store it in any way, I say in some way that the share of storage depends on the solutions suggested to me, So I also openly think about it.

Any help will be great because I am scratching my head over it.

This is actually a tool created in a SQL Management Studio.

Please refer the attached link in this regard

Once set up, all events will be recorded in the error log.


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -