Post reply

Changing the size of a column from varchar (8000) to Varchar(Max) Timing Out

  • February 8, 2008 at 10:27 am

    #120574

    I am trying to change the size of a column on a very large table and it is timing out. Any thoughts on how to get this to go through?

  • February 8, 2008 at 10:33 am

    #776521

    do it from a query window. It will continue executing.

    syntax would look like

    alter table mytable

    alter column bob2 nvarchar(500) --or whatever size, etc. you wish

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply