-- Table containing the lock request mode values and text.
if object_id('syslockreqmode') is not null and 
        objectproperty( object_id('syslockreqmode') , 'IsUserTable' ) = 1
        drop table syslockreqmode
go
create table syslockreqmode(req_mode int not null, req_mode_text varchar(30) not null)
insert into syslockreqmode values (0, 'NULL (No access is granted)')
insert into syslockreqmode values (1, 'Sch-S (Schema stability)')
insert into syslockreqmode values (2, 'Sch-M (Schema modification)')
insert into syslockreqmode values (3, 'IS (Intent Shared)')
insert into syslockreqmode values (4, 'SIU (Shared Intent Update)')
insert into syslockreqmode values (5, 'IS-S (Intent Shared-Shared)')
insert into syslockreqmode values (6, 'IX (Intent Exclusive)')
insert into syslockreqmode values (7, 'SIX (Shared Intent Exclusive)')
insert into syslockreqmode values (8, 'S (Shared)')
insert into syslockreqmode values (9, 'U (Update)')
insert into syslockreqmode values (10, 'IIn-Nul (Intent Insert-NULL)')
insert into syslockreqmode values (11, 'IS-X (Intent Shared-Exclusive)')
insert into syslockreqmode values (12, 'IU (Intent Update)')
insert into syslockreqmode values (13, 'IS-U (Intent Shared-Update)')
insert into syslockreqmode values (14, 'X (Exclusive)')
insert into syslockreqmode values (15, 'BU (Bulk Operation)')
go
-- Table containing the lock request type values and text.
if object_id('syslockreqtype') is not null and 
        objectproperty( object_id('syslockreqtype') , 'IsUserTable' ) = 1
        drop table syslockreqtype
go

create table syslockreqtype (req_type int not null, req_type_text varchar(15) not null)
insert into syslockreqtype values(1, 'NULL Resource')
insert into syslockreqtype values(2, 'Database')
insert into syslockreqtype values(3, 'File')
insert into syslockreqtype values(4, 'Index')
insert into syslockreqtype values(5, 'Table')
insert into syslockreqtype values(6, 'Page')
insert into syslockreqtype values(7, 'Key')
insert into syslockreqtype values(8, 'Extent')
insert into syslockreqtype values(9, 'RID (Row ID)')
go

This page was last updated on May 01, 2006 04:28 PM.