Server Trigger: connection_limit_trigger_2 Server Trigger: connection_limit_trigger_2| Property | Value |
|---|---|
| Trigger Name | connection_limit_trigger_2 |
| Trigger ID | 1243151474 |
| Trigger Type | SQL trigger |
| Enabled |
|
| Microsoft Shipped |
|
| Uses ANSI NULL |
|
| Uses QUOTED IDENTIFIER |
|
| Modify Time | 9/26/2010 1:15:55 AM |
| Create Time | 9/26/2010 1:15:55 AM |
| Event Type | First | Last | Event Group Type |
|---|---|---|---|
| LOGON |
|
|
|
| CREATE_DATABASE |
|
|
| Script |
|---|
| CREATE TRIGGER connection_limit_trigger_2 ON ALL SERVER WITH EXECUTE AS 'login_test' FOR LOGON, CREATE_DATABASE AS BEGIN IF ORIGINAL_LOGIN()= 'login_test' AND (SELECT COUNT(*) FROM sys.dm_exec_sessions WHERE is_user_process = 1 AND original_login_name = 'login_test') > 3 ROLLBACK; END; |