To stop the table locking you could use a rowlock hint:

-- Ensure we are using row-level locking
SELECT @intID = (idPool + 1)
  FROM IdConfiguration WITH...

DECLARE  @intID    BIGINT
        ,@bridgeid BIGINT = 1
;
 UPDATE dbo.bridge 
    SET...

Try not to specify the idPool column twice in the same Update statement and get rid of the Select statement.

The select statement where criteria is the same as the...

The Dynamic SQL is executed in a different context.

This is a classic "Get NextID" issue.

It would also be nice if, when you posted a code example to explain your problem, that it would at least compile.  BridgID is...

Thank you!  That'll help others, as well as preventing future dead links.

Just to add to this (Great question, BTW!)...

The zero is known as a "Date Serial" number.  DATETIME and SMALLDATETIME are capable of using Date Serial numbers directly whereas DATE, DATETIME2...

My biggest problem with all of this is that people keep poo-pooing the words "perfect" and "perfection".  That, in itself, isn't a problem but what people think after all the...

Hello Jeff. Thanx for reply. I have never come across synonyms. Read some info on it. I am not really sure it will work. Anyways the old data will...

Have two tables... for example, TableA1 and Table A2.

Start out with a synonym called TableA and have it pointing at TableA1.

Have another synonym called TableAWork and have it pointing at...

Might just be me but the only time I'll look at any missing index recommendations is when there's a slow query that could really use some help.  Adding indexes is...

What is supposed to happen to the 5 million rows in Table A AFTER you've copied them to Table B and is Table B on the same database and on...

I agree with David Poole.  To put it all in less formal terminology, I've found that tools like ChatGPT are nothing more than a very sophisticated consensus engine and, sadly...

So, are you leaving all of this up to us to contact @marketing, etc?

IMHO, true experts have enough knowledge about a particular subject to know when they don't know something about that subject and aren't afraid to say so.  Saying "I don't know"...