Listing 3: Code That Creates the Sessvars Table

CREATE TABLE [dbo].[sessvars] (
  [Rec_ID] int IDENTITY(1, 1) NOT NULL,
  [GUID] varchar(50) DEFAULT(0) NULL,
  [User_IP] varchar(50) DEFAULT(0) NULL,
  [User_Agent] varchar(255) DEFAULT(suser_sname()) NULL,
  [SVar_Date] smalldatetime DEFAULT(getdate()) NULL
)
GO