Post reply

Timeout exception while alterig table defination

  • March 2, 2010 at 11:18 pm

    #230449

    Hi to all out there,

    i am trying to add identity to one of my table which is having rows nearby 19 lacs. But i am not able to do so as it is giving me Time out error due to large no of data. I tried with changing override transaction property in tools option to 300 secs... But it is not working...

  • March 10, 2010 at 3:04 pm

    #1131669

    Is this being done through Management Studio, if so, are you able to script out the change and see what is occurring, is the change creating drop and recreation and reinsertion of data into the table, are any other tables affected, FK constraints etc. Is the change going to take some time, if so, if it is not production, you are able to take potential downtime while it finishes, script out the change and run the script.

    Management studio does a lot in the background after you make changes in design mode depending on your schema?

    Andrew

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

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