Post reply

I'm altering a column type of a table.

  • May 4, 2015 at 9:54 am

    #398405

    I have a table which has a lot of records. Every time I try to change the colantion of the column I get a timeout.

    Do you guys have any ideia of the best way to do this?

    Maybe the only way is to drop the column an create again using the alter table comand....

  • May 4, 2015 at 9:56 am

    #1795404

    Or create a new column with ne collation, move the data from the old column to the new column, drop the old column, rename the new column to the old column name.

    Just a thought.

  • May 4, 2015 at 10:01 am

    #1795406

    Don't use the GUI.

    The T-SQL query window in SSMS doesn't have a timeout set (the GUI does), so a written query will run as long as necessary. It may be very long if the table is large.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 4, 2015 at 10:04 am

    #1795409

    thank you

Viewing 4 posts - 1 through 3 (of 3 total)

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