Hi,
I am trying to change a PK column of a large SQL Server table to set Identity On. I do that in SSMS. But I suppose since the table is fairly large (about 600,000 rows) it runs out of time and the process is never completed.
Is there a way to increase amount of time SQL Server allocates for such process so that I can make the change?
TIA.
UPDATE: Found the setting in Tools -> Options -> Design. Set the value from 30 to 180. The strange thing, however, when I went back to the table where I wanted to change the column the Identity is Yes. And I thought that when I tried first time it reported that the update could not been completed.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham