This SP is inside another SP which then call another SP that updates mcpITEMTASKS, because of that I believe they use the UPDLOCK to update the rows later, have to...

That was the picture of the actual execution plan, but I'm attaching now one from the new actual and estimate execution plan (as I created the recommended index from the...

Thanks ALZ

Attached is the exec plan, as you said there is in fact an index scan, but on mcpitems, not on mcpitemtasks where the updlock is and the deadlocks occur,...

Thanks Gila, I'll check it out to see if i can find something.

It was a very nice approach, it seems I'll just keep the SPs execution history withouth parameters for now.

Thanks for all your valuable help guys.

Yeah, I wanted to see if there was a way through DMVs, other than traces or inputbuffer, I'll take a look and let you know if I can workout somethings.

Thanks...

I'll take a look and see what I can find, and yeah, I was trying to get something like "exec sp_test 'data1',2, etc..." like what you get in traces RPC...

Yeah i actually said users to copy & paste data in 1 sheet and always place the file allways in the same path cuz it was much more work doing...

Got it, thanks guys 🙂

yeah the query is giving a 99% clustered index on the plan, I'll try adding as you say an index or splitting the table and let you know how it...

After attaching the db i tried running this:

sp_configure 'Cross DB Ownership Chaining',1

RECONFIGURE WITH override

but it didn't helped, I also runed this:

sp_change_users_login 'AUTO_FIX','user'

On the user that I'm granting select permission on...

Hi guys

No one has replied, I'm wondering if I didn't made myself clear or it is a very weird error you can't figure how to solve?

Thanks

It worked, just have to add the Success column to check that if permission is denied value = 0, else value = 1.

Thanks I'll check it out

Thanks Jack I'll take a look.