title: how to rename column name with T-SQL
body: <p>I need help with SQL Server Table Column.
  I´m trying to rename Column Name, but this doesn't work.</p>
  
  <pre><code>USE COST_mesta_test
  GO
  EXEC sp_rename '[dbo].[1965$].obec' , 'people' , 'COLUMN'
  GO
  </code></pre>
  
  <p>I tried different combination of brackets [] and path to table "obec"
  (for example: 1965.obec; 1965$.obec; 1965.[obec]; etc.)
  But still i get an error:</p>
  
  <blockquote>
    <p>Either the parameter @objname is ambiguous or the claimed @objtype
    (COLUMN) is wrong.</p>
  </blockquote>