SQLServer 2008 trigger and login

Hello, I have issue the following command and would like to drop the login_test but I cannot drop it because of the trigger which has been created, where or how do I find this trigger to drop it first.

USE master;
GO
CREATE LOGIN login_test WITH PASSWORD = '3KHJ6dhx(0xVYsdf' MUST_CHANGE,
    CHECK_EXPIRATION = ON;
GO

GRANT VIEW SERVER STATE TO login_test;
GO

CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'login_test'
FOR LOGON
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;

vera2006Asked:
Who is Participating?
 
rajeevnandanmishraCommented:
In the Server Objects -->Triggers
0
 
rajeevnandanmishraCommented:
You can also use the drop trigger statement like,
DROP TRIGGER [connection_limit_trigger] ON ALL SERVER
0
 
BartVxCommented:
They can be found in the sys.triggers view of the master database.

Check following links for more info:

How to drop a DDL trigger:

http://msdn.microsoft.com/en-us/library/ms173497.aspx

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.