>Hi,
>
>I need to change a PK field type of a table (from NUMERIC(6,0) to INT since the value is approaching 1,000,000). I have done it for other customers but here (for this customer) I have some concerns. The number of rows in the table is about 700,000 and the rows have many columns. So the change in SSMS takes some time. I connect to the customer SQL Server from my SSMS while VPN to their network.
>
>My question is, where does the amount of memory matter for this change, on my computer or on the customer server where SQL Server is installed?
The SQL Server computer's memory will play an effect, your local computer memory doesn't matter.
I think you probably would like to create a new table with the correct structure, move rows from the old table, rename the old, rename the new. If there are FK relations involved it may be even more problematic.
If it's not broken, fix it until it is.
My Blog