I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server

We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a
"Lock request time out period exceeded." error.

The SP basically does a lot of table Truncates and then INSERT INTO from a table. Fairly small tables (hundreds of records).

I am setting the TUniConnection SQL Server.LockTimeout=-1 (in the SpecificOptions). It is being set ok at the component, but it does not seem to have any effect. I can change this time from virtually anything to -1 and the server times out in about 2 seconds.

Most queries seems to work just fine and I do not get the timeout issues. This particular one seems an issue. But I am wondering why the SQL Server timeout does not seem to be set at all with this option.

Is there something else I need to set or check?