Post reply

Can't make column as identy to Yes

  • October 13, 2010 at 5:31 am

    #141004

    Hello, I am trying to make a column as identy to Yes Tabel have a lot of rows and I get error message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Please help me to fix it.

    Thank you

  • October 13, 2010 at 7:05 am

    #1236163

    Behind the scenes, the table gets dropped and re-created.

    If it holds lots of data, timeout expires from SSMS.

    Do it manually or, even better, add a new column with identity attribute, drop the old column and rename the new column as the original one.

    -- Gianluca Sartori

  • October 13, 2010 at 7:41 am

    #1236196

    Perhaps scripting the change to a job, instead of SSMS would work.

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

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