Try inserting the rows that need to be deleted into a temporary table then another step to delete the rows:

SELECT DEM.NUM_DEM 
  INTO #RESULTS_TO_DELETE
  FROM...

This isn't...

I think the first thing to do is to try to optimise the query to make it run faster as frederico suggested.

ChatGPT is really good at explaining things like that. Just paste the error message into it.

If the index doesn't already exist you need to remove DROP_EXISTING = ON from the index creation or set it to OFF.

• This reply was modified 3 years, 5 months ago by Jonathan AC Roberts.

It can't... there's no ORDER_ID column in the...

I would guess one or maybe both of these indexes would fix your problem:

 CREATE INDEX IX_c_b_party_comm_1 
     ON dbo.c_b_party_comm(ROWID_OBJECT, COMM_TYP_CD) 
INCLUDE (COMM_TYP_CD,...

Okay I am not understanding your comment "I have a feeling it is taking it literally as a string" -- how else should it take it? I mean you...

try:

 like '%' + p.forenames + '%'

So it it the case that there is an AD account that you can remotely connect but the SQL login cannot remotely connect?

If it works when they remote to the host...

I've got no idea but ChatGPT suggested:

Error 18456 is a common error in Microsoft SQL Server, indicating that a login attempt has failed due to invalid login credentials or insufficient...

You can print the SQL statement instead of executing it and then run it manually.

Someone like Paul White could answer...

Why does creating and inserting data into a table with insert into cause blocking but inserting into an existing table not cause blocking?