• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

sql server 2008 can not save new colum

How can I create new column and update in column in my database table in SQLserver 2008. When I save it , they force me to save in text file and the warning message below appear all the time. Finally I can not save my new column that I make. I can not turn off my computer now...since my new table that I make will disappear when  I turn off.  Please help me ?
can-not-save.JPG
0
teera
Asked:
teera
  • 2
2 Solutions
 
chapmandewCommented:
are you saving the column at the end of the table or in the middle?
0
 
i2mentalCommented:
You can go into your options and change the new to 2008 value that prevents the gui from rebuilding a table. Or you can take the text of that change and run it in a query window.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now