Martin Reid
mwp.reid at qub.ac.uk
Tue Feb 2 10:14:27 CST 2010
John 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 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 www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com