Hot answers tagged

1

I've seen some options in .NET be different than the default SSMS options. Specifically, ARITHABORT was ON in SSMS, but in .NET it was OFF (the default value in the DB was off, where I assume .NET was pulling this from). This caused SQL Server to choose a vastly different (and terrible) plan in the .NET code. Can you verify the options (ANSI_NULLS, ...



Only top voted, non community-wiki answers of a minimum length are eligible