title: SQL server 2005 query not running
body: <p>Before posting this question, I have tried so many things but that was not helpful for me.
  I want to rename  the column of table at sql server 2005, following query I have run at sql server2005:</p>
  
  <blockquote>
    <p>1) ALTER TABLE Details RENAME COLUMN
    AccountID TO UID; but it gives me the
    error: Incorrect syntax near the
    keyword 'COLUMN'.</p>
    
    <p>2)I have added one new column in the
    table by query:  ALTER TABLE Details
    ADD BID uniqueidentifier;   and then I
    want to set the coulmn property to not
    null .</p>
  </blockquote>
  
  <p>How can i do that?</p>
  
  <p>Thanks in advance
  AS</p>