Posted by DaveP on 02/15/07 15:05

thanks for the responses...
dave

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98D24AF9ACFYazorman@127.0.0.1...
> DaveP (dvs_bis@sbcglobal.net) writes:
>> 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
>
> This is a metadata change, so it will be about instant.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Performance
• Prev in forum: Sql server process memory question
• Thread view: Re: Column update structure change

[Reply to this message]