Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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">
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Consume a webservice via VB in Visual Studio 2015||3||22|
|Convert VB web project to C#||3||43|
|Inserting LocalDB Table to SQL Server C#||3||23|
|using an update statement with 3 tables but need to get minimum receipt date need help finishings||4||16|