Forum Discussion
the SQL server database engine cannot obtain a lock ressource at this time
hello I have a problem with the configuration of SQL Server I have SQL Server 2019 with the last cumulative update i fixed the max server memory with 40000 Mo =40 Go and maxdop to 0 i have e...
Try to set Database recovery model to 'Simple' or 'bulk-logged', and use exclusive lock on target table like below
insert into table A WITH (TABLOCK) select * from table B
insert into table A WITH (TABLOCK) select * from table B