Salut,
am o tabela cu 10000054 inregistrari, obtinuta prin bulk insert. Vreau sa pun un PK de tip int, isidentity. Daca incerc sa modific strunctura tabelei din SSMS, imi crapa cu eroarea:
"
Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
"
dupa ce ma avertizeaza in prealabil:
"Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible."
Cum sa procedez? vreau PK...
Multumes,
Lucian