title: SQL SERVER and SET ANSI_NULLS ON, SET QUOTED_IDENTIFIER ON
body: <p>So I have been blindly using ansi_nulls on, quoted_identifier on when creating scripts, because sqlserver generates them automatically when scripting objects.. </p>
  
  <p>I don't really have time to concern myself with such trivial non-sense :-) But i guess the questions have got to be asked.</p>
  
  <p>Given that these are the recommended settings, is there an option that can be set (a) per database, and (b) per server, So that they are ALWAYS ON by default, rather than by individual scripts?</p>
  
  <p>And if so, how / where can the current default settings be viewed?</p>