1. Start SQL Server Management Studio on the server machine
2. Provide credentials for the user 'sa' and login
3. Click the New Query button on the toolbar. A blank query window will open
4. Copy the query text (in blue) below and paste it in the blank query window.
Please Note: We are assuming that the name of the GLOBODOX Main Database is named MainDB. If not, please replace MainDB in the text below with the name of the GLOBODOX Main Database listed in SQL Server Management Studio
USE [MainDB]
GO
DROP TABLE [dbo].[tblLogonSession]
GO
CREATE TABLE [dbo].[tblLogonSession](
[UserID] [int] NULL,
[MachineName] [nvarchar](255) NULL,
[AppType] [int] NULL,
[LogonDateTime] [datetime] NULL,
[LastAccessedDateTime] [datetime] NULL,
[LicenseType] [int] NULL,
[AppName] [nvarchar](255) NULL,
[ServiceTicket] [ntext] NULL,
[SessionPointer] [nvarchar](32) NULL,
[ActivationCount] [int] NULL,
[TicketID] [nvarchar](255) NOT NULL,
CONSTRAINT [idx_tblLogonSession] PRIMARY KEY CLUSTERED
(
[TicketID] ASC
)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
5. After pasting the text in the query window click the Execute button on the toolbar
6. You should see a message Commands completed successfully.
7. Run GLOBODOX