connections

• hbk_sql

  SSC-Addicted

  Points: 425

  More actions

  May 5, 2011 at 10:49 am

  #235830

  Hi,

  we are using SQL Server 2008 version for our production server.

  right now we are auditing failed and successfull logins, now we want to track of all connection attempts to sql server. how can we do this?

  and just wondering whether it will generate excessive logging if tracking of connection attempts is enabled. Thanks for your help.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 5, 2011 at 11:20 am

  #1320578

  Check out this article:

  http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/