[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
> 
>