Home Forums SQL Server 2005 Administering Identity column maxed out RE: Identity column maxed out

  • December 21, 2009 at 1:01 pm

    #1095038

    Joe-420121 (12/21/2009)

    The following procedure is OK?

    1. Create Table [backup12212009] with BIGINT Indentity

    2. using SSIS export data from old table to [backup12212009]

    3. Delete old table

    4. Rename backup12212009

    Can do as above?

    if there are any dependent foreign keys on the table, or if the table has any constraints or defaults then no, that is NOT the way to do it.

    doing a full backup and additionally backing up the table as Jason suggested, and then using the SSMS GUI is the way to do it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!