I have been testing logon trigger from the following link: http://msdn.microsoft.com/en-us/library/bb326598.aspx
Everything works fine, I got my results but now I can't drop the trigger. I get the following error:
Msg 3701, Level 11, State 5, Line 1
Cannot drop the trigger 'dbo.connection_limit_trigger', because it does not exist or you do not have permission.
I can ALTER the trigger but thats all. I even tried to log in as SA event though I am sysadmin on the server.