gistfile1.sql

CREATE TABLE [dbo].[SessionParameters]
(
	[SessionId] SMALLINT NOT NULL,
  [PKey] NVARCHAR(128) NOT NULL, 
  [PValue] NVARCHAR(MAX) NULL, 

  CONSTRAINT [PK_SessionParameters] PRIMARY KEY ([SessionId], [PKey]) 
)
GO

CREATE VIEW [dbo].[UserSessionParameters]
AS SELECT
    [PKey],
    [PValue]
  FROM [SessionParameters]
  WHERE [SessionParameters].[SessionId] = @@SPID
GO

INSERT INTO [dbo].[UserSessionParameters] VALUES ('LogonTime', GETDATE())
GO