createlog.sql

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
 -- DROP TABLE [dbo].[FlowStatusLog]

GO

CREATE TABLE [dbo].[FlowStatusLog](
	[id] [bigint]  NOT NULL,
	[correlation] [nvarchar](100)  NOT NULL,
	[application] [nvarchar](50) NULL,
	[subject] [nvarchar](50) NULL,
	[body] [nvarchar](500) NULL,
	[email] [nvarchar](100) NOT NULL,
	[datetime] [datetime] NULL,
	[status] [nvarchar](10) NULL
 CONSTRAINT [PK_FlowStatusLog] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


-- This has designed to be used in Microsoft Flow - Flow having issues with update operation on identify columns
-- Check - https://powerusers.microsoft.com/t5/Building-Flows/Update-a-row-in-SQL-Server-fails-because-the-ID-for-update-is/td-p/45189
-- GetTicks(Now())