Alter Column Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 27 Mar 2008 20:11 GMT

Hello,

I have a table with 10million rows where I need to change the datatype on a
column from int to bigint. I'm assuming this will take a long time to
complete by just going in to Management Studio changing the datatype and
saving.

Any tips on speeding up the process?

Thanks in advance.
Any help appreciated!

Reply to this Message

David Portas - 27 Mar 2008 21:18 GMT

> Hello,
>
[quoted text clipped - 8 lines]
> Thanks in advance.
> Any help appreciated!

Do not use the Management Studio UI to do such things. Create an ALTER
script, test it in a test environment then run it on your target system. The
Management Studio UI is not the best way because it does some things behind
the scenes that may not be obvious unless you review the commands before you
execute them.

Signature

David Portas

Reply to this Message