Tables [dbo].[sa_virtual_session]
Properties
PropertyValue
Row Count183
Created4:36:11 PM Wednesday, March 24, 2010
Last Modified4:36:11 PM Wednesday, March 24, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__sa_virtual_sessi__5708E33C: ididint4
No
last_mod_bybinary(16)16
Yes
last_mod_dtint4
Yes
queueIDint4
Yes
userIDbinary(16)16
Yes
sessionIDint4
Yes
queuedEpochint4
Yes
handledEpochint4
Yes
endEpochint4
Yes
waitTimeint4
Yes
handledTimeint4
Yes
abandonFlagint4
Yes
firstFlagint4
Yes
tenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__sa_virtual_sessi__5708E33C: idPK__sa_virtual_sessi__5708E33Cid
Yes
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
Extended Properties
NameValue
CommentAdded r12.5
SQL Script
CREATE TABLE [dbo].[sa_virtual_session]
(
[id] [int] NOT NULL,
[last_mod_by] [binary] (16) NULL,
[last_mod_dt] [int] NULL,
[queueID] [int] NULL,
[userID] [binary] (16) NULL,
[sessionID] [int] NULL,
[queuedEpoch] [int] NULL,
[handledEpoch] [int] NULL,
[endEpoch] [int] NULL,
[waitTime] [int] NULL,
[handledTime] [int] NULL,
[abandonFlag] [int] NULL,
[firstFlag] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[sa_virtual_session] ADD CONSTRAINT [PK__sa_virtual_sessi__5708E33C] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[sa_virtual_session] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[sa_virtual_session] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[sa_virtual_session] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[sa_virtual_session] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[sa_virtual_session] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'sa_virtual_session', NULL, NULL
GO
Uses