Cross db ownership chaining.

In ssms, the login is mapped to users in both databases.

in the agent job, (or in a stored proc with ' execute as') the login no...

We ended up doing something like this:

(ISNULL([Target.RebateDay] != [Old.RebateDay]) ? !(ISNULL([Target.RebateDay])...

Beware that this approach doesn't seem to work well with big tables. If you have many millions of rows and a couple dozen columns, you will run out of memory,...

This is what I'm seeing (sp_lock) in the Management Studio when I'm running the statement with the updlock:

spid dbid ObjId ...

Gail,

thank you for your response. I tried the xlock hint like this

insert into deleteme

select #t.id, 'test' from #t

left join deleteme with (xlock) on deleteme.id = #t.id

where deleteme.id is...