ALTER Proc [dbo].[WebServiceAccess_Insert] @Duration smallint, @Company varchar (10), @UserId varchar (47), @WindowsUserId varchar (85), @OnBehalfOf varchar(47), @SecToken uniqueidentifier, @Culture varchar (30), @SessionEncoding varchar(1) as
INSERT INTO [WebServiceAccess] ([LastActivity],[TimeoutDuration],[CompanyID],[UserId],[WindowsUserId],[OnBehalfOf],[ID],[Locale],[Encoding])
VALUES(CURRENT_TIMESTAMP, @Duration, @Company, @UserId, @WindowsUserId, @OnBehalfOf, @SecToken, @Culture, @SessionEncoding)
=================================================
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WebServiceAccess](
[LastActivity] [datetime] NOT NULL,
[TimeoutDuration] [smallint] NOT NULL,
[CompanyID] [char](10) NOT NULL,
[UserId] [char](47) NOT NULL,
[WindowsUserId] [char](85) NOT NULL,
[OnBehalfOf] [char](85) NOT NULL,
[ID] [uniqueidentifier] NOT NULL,
[Locale] [char](30) NOT NULL,
[Encoding] [char](1) NOT NULL,
[tstamp] [timestamp] NOT NULL,
[BusinessDate] [smalldatetime] NOT NULL,
[CustomizationLevel] [smallint] NOT NULL,
[CustomGrpID] [char](30) NOT NULL,
[InitializationMode] [char](1) NOT NULL,
[UserrecID] [char](47) NOT NULL,
CONSTRAINT [WebServiceAccess0] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
-------------------
We are migrating from 2015 to 2018 version
