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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply