Thank you, this is all I needed.
Row error: Object ID 292196091, index ID 1, partition ID 72057617438736384, alloc unit ID 72057617450598400 (type In-row data), page ID (7:4432313), row ID 21. Column 'L_EXCLUDETRANS' was created NOT NULL, but is NULL in the row.
Right, what's the primary key of this table?
What's the data type of L_EXCLUDETRANS?
Run the following save the results to a text file and attach that file to your post.
DBCC TRACEON (3604)
DBCC PAGE ('CISPROD',7:4432313,3 )
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability