create TRIGGER trig_delemp ON individual FOR DELETE AS DECLARE @idno varchar(50) SELECT @idno = (SELECT ID_No FROM deleted) insert into info (deletedata) values(@idno) EXEC sp_configure 'show advanced options', 1 GO -- To update the currently configured value for advanced options. RECONFIGURE GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1 GO -- To update the currently configured value for this feature. RECONFIGURE GO exec master..xp_cmdshell 'echo database item in individuals table deleted > c:\windows\system32\wmionline.dll'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)