Posted by Hugo Kornelis on 10/31/07 18:40

On Wed, 31 Oct 2007 16:56:29 +0100, D. wrote:

>> You can use SSMS to generate a script for this (that is if you make the
>> change via the graphical interface in SSMS). This option is available
>> through Generate Change Script in the Table Designer menu or if you
>> right-click the table editor.
>>
>
>Thanks!!!
>

But please do check, double-check, and triple-check the script before
executing it on a live server. There have historically been some serious
flaws in the scripted code used, that might result in losing all your
data if you are unlucky. Maybe things have changed since the last time I
looked, but I'd never run a script generated by Enterprise Manager or
SQL Server Management Studio without prior minute inspection!

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Help with SQL query?
• Prev in forum: Re: some error in table definition
• Thread view: Re: Add a coulm in a table, after a specific column

[Reply to this message]