jwcolby
jwcolby at colbyconsulting.com
Tue Feb 2 10:53:55 CST 2010
It apparently somehow preserves the data yes? That is a cool trick, though of course as you mentioned, it would not be very efficient with large tables. John W. Colby www.ColbyConsulting.com Martin Reid wrote: > John > > It could cause problems with large tables such as those you are using. It drops and recreate the table. I think you are better using Alter Table > > 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:34 > To: Discussion concerning MS SQL Server > Subject: Re: [dba-SQLServer] SQL Server 2008 - Changes made > > Thanks, that did it. > > What gremlins am I unleashing by doing this? > > John W. Colby > www.ColbyConsulting.com > > > Martin Reid wrote: >> 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 >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >