Ni­PDB_log Database

Files

Name Type Size Maxsize Autogrowth File Name

Ni­PDB_log

Data

8,00 MB

unlimited

64,00 MB

C:\Program Files\Microsoft SQL Server\
MSSQL14.MSSQLSERVER\MSSQL\DATA\Ni­PDB_log.mdf

Ni­PDB_log_log

Log

8,00 MB

2048,00 GB

64,00 MB

C:\Program Files\Microsoft SQL Server\
MSSQL14.MSSQLSERVER\MSSQL\DATA\Ni­PDB_log_log.ldf

Tables

  • [dbo].[log_ents]

[dbo].[log_ents]

Properties

Property Value

Collation

Finnish_­Swedish_­CI_­AS

Row Count (~)

0

Created

10:55:40 den 14 mars 2018

Last Modified

11:04:45 den 14 mars 2018

Columns

Key Name Data Type Max Length (Bytes) Allow Nulls Identity

000046

log_ents_id

int

4

False

1 - 1

log_ent_level

int

4

False

log_ent_type

int

4

False

log_ent_created

datetime

8

True

log_ent_client_id

nvarchar(100)

200

True

log_ent_data_text

nvarchar(max)

max

True

log_ent_org_name

nvarchar(100)

200

True

log_ent_last_row

varbinary(max)

max

True

log_ent_signature

varbinary(max)

max

True

log_ent_usr_disp_name

nvarchar(200)

400

True

log_ent_usr_uniq_name

nvarchar(500)

1000

True

log_ent_tkn_snr

nvarchar(100)

200

True

log_ent_tkn_seqnr1

nvarchar(100)

200

True

log_ent_tkn_seqnr2

nvarchar(100)

200

True

log_ent_tkn_tml_name

nvarchar(300)

600

True

log_ent_end_usr_disp_name

nvarchar(200)

400

True

log_ent_end_usr_uniq_name

nvarchar(500)

1000

True

log_ent_crt_snr

nvarchar(100)

200

True

log_ent_adnl_info

nvarchar(max)

max

True

log_ent_org_ofc_name

nvarchar(100)

200

True

log_ent_crt_cn

nvarchar(500)

1000

True

log_ent_data

varbinary(max)

max

False

log_ent_usr_snr

nvarchar(100)

200

True

log_ent_end_usr_snr

nvarchar(100)

200

True

log_ent_data_text

nvarchar(max)

max

True

log_ent_task_obj_descr

nvarchar(500)

1000

True

Indexes

Key Name Key Columns Unique

000046

PK_log_ents_id

log_ents_id

True

SQL Script

CREATE TABLE [dbo].[log_ents]
(
[log_ents_id] [int] NOT NULL IDENTITY(1, 1),
[log_ent_level] [int] NOT NULL,
[log_ent_type] [int] NOT NULL,
[log_ent_created] [datetime] NULL,
[log_ent_client_id] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_org_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_last_row] [varbinary] (max) NULL,
[log_ent_signature] [varbinary] (max) NULL,
[log_ent_usr_disp_name] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_usr_uniq_name] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_tkn_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_tkn_seqnr1] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_tkn_seqnr2] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_tkn_tml_name] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_end_usr_disp_name] [nvarchar] (200) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_end_usr_uniq_name] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_crt_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_adnl_info] [nvarchar] (max) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_org_ofc_name] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_crt_cn] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_data] [varbinary] (max) NOT NULL,
[log_ent_usr_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[log_ent_end_usr_snr] [nvarchar] (100) COLLATE Finnish_­Swedish_­CI_­AS NULL
[log_ent_data_text] [nvarchar] (max) COLLATE Finnish_Swedish_CI_AS NULL,
[log_ent_task_obj_descr] [nvarchar] (500) COLLATE Finnish_Swedish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_­ON [PRIMARY]
GO
ALTER TABLE [dbo].[log_ents] ADD CONSTRAINT [PK_log_ents_id] PRIMARY KEY CLUSTERED ([log_ents_id]) ON [PRIMARY]
GO