[dba-SQLServer] SQL Server 2008 - Changes made

Martin Reid mwp.reid at qub.ac.uk
Tue Feb 2 10:14:27 CST 2010


Try this

"Within SQL Management Studio click on the Tools menu. Then Options, then the Designer node and uncheck the box that says: Prevent saving changes that require the table to be re-created."


Martin WP Reid
Information Services
The Library at Queen's
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
Sharepoint Training Portal
From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby [jwcolby at colbyconsulting.com]
Sent: 02 February 2010 16:09
To: Sqlserver-Dba
Subject: [dba-SQLServer] SQL Server 2008 - Changes made

I am consistently getting an error "the changes you made would require the table to be dropped and
recreated".  This seems to be pretty much ANY change to the table in design view.  Is it my
imagination or did a lot of these changes used to be possible in SQL Server 2005?  Is it something
else that I don not understand?

John W. Colby
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list