create table dbo.ROLE_NODE (
ROLE_ID varchar(64) not null,
NODE_ID varchar(64) not null,
WRITEFLAG   char(1) DEFAULT    'N'          not null,
constraint PK_ROLE_NODE PRIMARY KEY CLUSTERED ( ROLE_ID,NODE_ID ) --
)
lock allpages --
on 'default'
go