[dba-SQLServer] SQL Server 2008 - Changes made

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