Home Forums SQL Server 2005 Administering restrict windows authentication login RE: restrict windows authentication login
pbedoya
SSC Journeyman
Points: 75
More actions
December 9, 2009 at 12:49 pm
#1090152
Must be:
CREATE TRIGGER connection_limit_trigger
ON ALL SERVER FOR DDL_LOGIN_EVENTS
I have gotten an error with "LOGON" clause...However msdn tell us:
CREATE TRIGGER XYZ
ON ALL SERVER {FOR|AFTER} LOGON ...