Restored DB Missing Table Attributes

  • I have restored a database from a production server to a development server.  All my tables, stored procedures, etc are there, but I seem to be missing some table/column attributes, namely the identity attribute on my primary key field.

    So now in development, when I do an insert to a table, I get the following;

    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'security_id', table 'ptc.dbo.user_security'; column does not allow nulls. INSERT fails.

    Does anyone know why this would be the case?

    Jeff

  • How you restored the database ?? using DTS ? or backup/restore?

    If you attempted DTS, whether you selected copying constraints ??

    Linto

  • I used restore database.  I copied the backup file from the production box to the development box, then restored using that disk file.

    Jeff

  • Check whether NOT NULL constraint is set on the production database for security_id column in user_security table.

    Linto

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

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