Maybe not relevant, but.... the column [LID] has datatype [int] with IDENTITY(1,1).

The table contains 2,163,568,622 rows.

Max size of an integer is 2,147,483,647.

I guess it's possible that negative numbers have been used, but otherwise I see a problem!