alert for db activity

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  November 16, 2016 at 7:25 am

  #323004

  Hi , is there a way i get alert for any kind of database activity without using any 3rd party tools? I have a server where i dont expect any activity as it is an old server but users still have access to it so i would like get an alert if any one is using any database on that server.

• Eric M Russell

  SSC Guru

  Points: 125564

  More actions

  November 16, 2016 at 7:34 am

  #1912789

  https://mssqltalks.wordpress.com/2013/02/25/how-to-audit-login-to-my-sql-server-both-failed-and-successful/

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

• November 17, 2016 at 3:18 am

  This was removed by the editor as SPAM