Skip to main content

11 things I wish I could tell myself as a Junior Software Developer – Michael’s Coding Spot

I’d like to tell my junior self that in 10 years, there wasn’t a single bug I didn’t eventually solve one way or the other. Even bugs that seem extremely scary, are eventually conquered. — Read on michaelscodingspot.com/2019/01/10/11-things-i-wish-i-could-tell-myself-as-a-junior-software-developer/

ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’

I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]