|
|
Posted by AlterEgo on 02/08/07 18:15
Dave,
First of all, SQL Server maximum rowsize = 8,060 bytes. Make sure you keep
under that limit when you add the #bytes from all of the other columns.
Access to the table, and possibly other objects that are dependent on that
table will be blocked until the schema change is complete. Also, other
non-dependent processes will also be slowed down significantly. A million
row table on recent sever technology should not take an excessive amount of
time to alter.
-- Bill
"DaveP" <dvs_bis@sbcglobal.net> wrote in message
news:S3Jyh.59511$wc5.47614@newssvr25.news.prodigy.net...
> hi
> I want to increase a varchar(5000)
> to varchar(8000) on a table that
> has approximately million rows.....
> What is the impact on the server
>
> or any good recomendations of a action to accomplish this in the best and
> fastest way.
>
>
> thanks davep
>
>
Navigation:
[Reply to this message]
|