Welcome to Sign in | Help

Adaugare de PK in tabla mare

  •  02-08-2010, 12:14 PM

    Adaugare de PK in tabla mare

    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
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems