1 reply to this topic

[Alberto Dominguez]

Ejemplos Triggers DML:

USE AdventureWorks2008
GO
CREATE TRIGGER Prueba ON Person.Person
AFTER DELETE AS
BEGIN
  SET NOCOUNT ON;
  INSERT INTO
  dbo.LOGs (JobCandidateID,  RejectedDate)
  SELECT JobCandidateID, getdate()
  FROM deleted
END

CREATE TRIGGER Prueba
ON Person.Person
INSTEAD OF DELETE 
AS 
  RAISERROR ('No está permitido borrar', 16, 10);
GO

[Alberto Dominguez]

CREATE TRIGGER AuditarOperaciones

ON DATABASE

FOR DDL_DATABASE_LEVEL_EVENTS

AS

  DECLARE @datos xml

  DECLARE @comandoejecutado nvarchar(350)

  DECLARE @logMsg nvarchar(400)

  SET @datos = eventdata()

  SET @comandoejecutado = @datos.value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]', 'nvarchar(350)')

  SET @logMsg = @comandoejecutado + ' (' + SYSTEM_USER + ' on ' + HOST_NAME() + ')'

  RAISERROR (@logMsg, 10, 1) WITH LOG

GO