[dba-SQLServer] SQL Server 2008 - Changes made

Hello Martin,

When you mention Alter Table, are you suggesting that instead of using the
GUI, to instead issue the direct DDL command.  If so, what you are saying is
that alter Table can modify the table without dropping and re-creating, but
the GUI cannot be as clever?  Poor show by the GUI developers if thats the
case.

If the above is correct then may I mention here a handy tip.  Have two
instances of the db (or even a bak file) and then using one of the sql diff
tools, that will generate a script that will give you the full required
tsql.  I guess the only thing to watch is does the sql diff tool also drop
the table and create.

Thanks

Mark



On 2 February 2010 16:42, Martin Reid <mwp.reid at qub.ac.uk> 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
>
>