can triggers be created in assemblies ?
Yes, it's possible to create a .NET CLR trigger.
How to: Create and Run a CLR SQL Server Trigger