General information
Forum:
Microsoft SQL Server
>Hi,
>Is it possible to create an alert that would be triggered if any connection established to SQL Server?
>
>Thank you
John,
Yes, it is possible. The most reliable way is to create a Windows Service that monitors the Event Log for new SQL Server login entries.
Also possible, but less reliable, is to examine the results of sp_who/sp_who2 in a DTS package that is scheduled to run every 2 or 3 seconds for a new connection. But you may miss a connection that opens and closes between queries.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only