How can we save changes that require table re-creation in sql server 2008?
When you work on sql server 2008 at first time to create table then want to change the type of field or rename.. ,after that you want to save, that will following by error message
To fix this problem
Following next steps:
1.Tools>>Options
2.Designers>>click on Table and Database Designers>>unchecked prevent saving changes that require table re-creation >>ok
Then you can change anything entire the table
19 Oct 2009
re-creation table in sql server 2008
Posted by
Hayfa
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment