February 25, 2004 at 9:42 am
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
February 25, 2004 at 3:04 pm
How you restored the database ?? using DTS ? or backup/restore?
If you attempted DTS, whether you selected copying constraints ??
Linto
February 25, 2004 at 3:13 pm
I used restore database. I copied the backup file from the production box to the development box, then restored using that disk file.
Jeff
February 25, 2004 at 3:15 pm
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