title: converting clustered index into non-clustered index?
body: <p>Is it possible to convert a clustered index to non clustered index or 
  non clustered index to clustered index in sql server 2005.</p>
  
  <p>Please convert this query into clustered index:</p>
  
  <pre><code>create index index1 on mytable(firstcolumn)
  </code></pre>
  
  <p>Please convert this query into non clustered index:</p>
  
  <pre><code>create clustered index clusindex1 on mytable(cluscolumn)
  </code></pre>