I want to generate an auto email if number of connections on database exceed. How can I do that?
Set up an Alert under SQL Server Agent
Object: SQLServer:General Statistics
Counter: User Connections
Instance: instance name if multiple instances
Alert if counter rises above: your max
Response: Notify operators
Choose who gets the email.
note you have to set up operators first