April 7, 2022 at 1:05 pm
Hi
I want if record added/updated in particular table before a particular date i should get message or notification or email should go.
Log should also get maintained of that entry
Thanks
April 7, 2022 at 1:32 pm
That is a requirement. But what is your question?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 7, 2022 at 2:38 pm
Hi
I want email should go and if date entered is < 30/03/2022 Below is the code
CREATE TRIGGER dbo.TRG_Users_ChangeTracking
ON dbo.Users
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO ChangeTrackingHistory(UserID)
SELECT i.UserID
FROM inserted AS i;
END
GO
Thanks
April 7, 2022 at 3:01 pm
sp_send_dbmail (link) will send an e-mail for you. But you still have not asked a question. Sample questions:
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply