Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
This is my update command used on the front end Gridview that that is associated to a drop down that a user selects within the griview:
USE [Abc] GO /****** Object: Trigger [dbo].[EmailRule1] Script Date: 3/3/2014 4:18:49 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[EmailRule1] ON [dbo].[Demographics1] AFTER UPDATE AS -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; --Makes sure that the decision was changed IF NOT UPDATE(DDecision) RETURN IF EXISTS(SELECT * FROM inserted a join deleted b on a.RFSID=b.RFSID WHERE ((B.DDecision <> 'RuleA' OR B.DDecision <> 'RuleB') AND b.IsComplete = 0) AND ((A.DDecision='RuleA' or A.DDecision='RuleB') AND A.IsComplete = 0)) BEGIN DECLARE @newDEmail varchar(64) DECLARE @newDFirst varchar(64) DECLARE @newDLast varchar(64) DECLARE @EmailBody varchar(MAX) -- Insert statements for trigger here SELECT @newDEmail=a.DEmail, @newDFirst=a.DFirst,@newDLast=a.DLast from inserted a join deleted b on a.RFSID=b.RFSID WHERE (B.DDecision <> 'RuleA' OR B.DDecision <> 'RuleB') and (a.DDecision='RuleB' or a.DDecision='RuleA') SET @EmailBody = ' Dear '+ @newDFirst + ' '+ @newDLast + ', Email message ' EXEC msdb.dbo.sp_send_dbmail @profile_name ='Abc', @from_address = '"Abc" <firstname.lastname@example.org>', @reply_to = email@example.com', @copy_recipients = ‘firstname.lastname@example.org', @blind_copy_recipients = ‘email@example.com’, @recipients = @newDEmail, @subject = 'Abc Application Eligibility', @body =@EmailBody END
UpdateCommand="UPDATE [Demographics1] SET [DWID] = @DWID, [DFirst] = @DFirst, [DLast] = @DLast, [DSubmitDate] = @DSubmitDate, [DDecision] = @DDecision, [DIsActive] = @DIsActive, [IsComplete] = @IsComplete WHERE [RFSID] = @RFSID">
|Upgrading my SSIS package in VS 2012||6||59|
|Vb.net threads keep increasing||2||35|
|Remove the Middle name initials and the suffixes from a string in SQL Server||3||17|