Feb 08, 2021 08:15 AM|Jerry Cai|LINK
By default,connections through Sql Server Management Studio have SET
ARITHABORT ON. But ADO.NET connections do not. It will use the
pre-compiled cached query plan that the SSMS was using, so it will be time out.
You can set it OFF When using stored procedure,
or using these code as admin on database, and then you can ignore the ARITHABORT settings.