title: SQL Server won't let me make column identity
body: <p>So I have a table in SQL Server w/ a primary key column, and 4 other columns. When I modify the table, and select the primary key column to be identity, it won't let me save the table.</p>
  
  <p>How can I make it an identity column through T-SQL or something without going to the UI?</p>
  
  <p>Thanks.</p>
  
  <p>Here's the create</p>
  
  <pre><code>USE [db]
  GO
  
  /****** Object:  Table [dbo].[tblMessages]    Script Date: 04/05/2011 11:58:25 ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [dbo].[tblMessages](
      [messageId] [int] NOT NULL,
      [messageText] [varchar](500) NOT NULL,
      [messageLatitude] [float] NOT NULL,
      [messageLongitude] [float] NOT NULL,
      [messageTimestamp] [datetime] NOT NULL,
  PRIMARY KEY CLUSTERED 
  (
      [messageId] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING OFF
  GO
  </code></pre>