CLR TRIGGER
Hello,
I have created CLR trigger (AdventureWorks database) and it works.
It exists in the sys.trigggers view, however, I do not see it in the database object browser.
If i try to DROP it, I get this message:
Cannot drop the trigger 'trcs_GetInsertUpdateDeleteInfo', because it does not exist or you do not have permission.
If i try to (re)CREATE it, I get this message:There is already an object named(the trigger name) in the database.
I think that I am dealing with some bug in SQL Server 2005, but I could be wrong of course.
If anybody faced the same problem, please let me know.
Thanks an regards.
Alex.
[1065 byte] By [AlexatNYC] at [2007-12-22] 