SQL Problem

Just had a strange SQL problem I’ve never had before..

I’ve moved onto a new project and took a back up of the database and put it on my local PC and when I came to run my code against it I got this error…

INSERT failed because the following SET options have incorrect settings: ‘ARITHABORT’.

I’m not a DBA I’m a programmer so I have no idea what this means, but if I get it again I know the following code will fix it…(which is nice)

ALTER DATABASE [DB_NAME]
SET ARITHABORT ON
GO

Leave a Reply

Security Code: