Ive recently upgraded to SQL 2008 and the first major difference i noticed was the inability to save changes to a table schema without dropping the contents of the table first (see dialog box below).
This is unacceptable in most cases, as I need to make changes to existing tables which contain large amounts of data.
After much googling I found a solution from Henry Cordes which did the trick.
Goto Tools > Options
And then goto Designers > Table and Database Designers and deselect the option 'Prevent saving changes that require table re-creation'
No comments:
Post a Comment