title: Unable to update sys.columns - any other approach?
body: <p>I just found out, that since I created my DB on a different server that had a different collation, then immigrated to a new server with new collation, now I keep on having trouble, and I decided to change all the values of the old collation.</p>
  
  <p>So I tried to execute this query:</p>
  
  <pre><code>sp_configure "Allow Updates", 1
  GO
  RECONFIGURE WITH OVERRIDE
  GO
  
  UPDATE sys.columns SET collation_name = 
      'SQL_Latin1_General_CP1_CI_AS' WHERE collation_name = 'Hebrew_CI_AS'
  GO
  
  sp_configure "Allow Updates", 0
  GO
  RECONFIGURE
  GO
  </code></pre>
  
  <p>But here is the output of the query:</p>
  
  <pre><code>Configuration option 'allow updates' changed from 0 to 1. 
      Run the RECONFIGURE statement to install.
  
  Msg 259, Level 16, State 1, Line 2
  Ad hoc updates to system catalogs are not allowed.
  
  Configuration option 'allow updates' changed from 1 to 0. 
      Run the RECONFIGURE statement to install.
  </code></pre>
  
  <p><strong>UPDATE</strong><br>
  According to the answers bellow, I am just looking for an automated way to perform the action.</p>