I want a trigger on the metadata table of CRM that fire when people delete fields.
This is working fine, but I don't know how to get the user who sent the request to delete the field.
There's any way to know this?
This is the trigger:
CREATE TRIGGER Trg_InsertMetadataAttributeDELETE ON metadataschema.Attribute AFTER DELETE AS BEGIN SET NOCOUNT ON; INSERT INTO MIGRACIONDATOS.TablaLogAtributos (Fecha, Entidad, Atributo) SELECT Getdate(), E.Name, A.Name FROM Deleted A INNER JOIN metadataschema.Entity E ON A.EntityID = E.EntityID END GO
The CRM organization is not upgraded to UR12 and it cannot be upgraded
UPDATE: It is not posible if the roll up if inferior to 12.