I don't 'see' a lock when I USE ADVENTUREWORKS.

Is the lock only present while making the context switch?

Ohhhh,

Well that makes sense. It had me seriously scratching my head. Thanks for the reply. 😎

Thanks for all the responses! While knowledge is a good thing, this has certainly complicated my design plans. But it is certainly better to know ahead of time...

opc.three

Your query is spot on! Best of all I can understand what it is doing. Thanks for the tip. I will also read the link you supplied...

Here is how I created the test data:

--DDL

CREATE TABLE MainTable_T(

Movie VARCHAR(30),

MainTable_ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED

)

CREATE TABLE AttributeType_T(

AttributeType VARCHAR(30),

AttributeType_ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED

)

CREATE TABLE AttributeValue_T(

MainTable_ID INT NOT...

Lowell,

The image did not post at first so I was confused. A second loading of the page produced the image and answered all my questions. Your suggestion...