sql server new users: Dear Sirs,
I have a traditional SQL 2005 Express table with fields,
e.g.

SubsurfaceID - (PKey) int, Not NULL (autoincremental from 1 by step 1),
Name - varchar,
Field1 stc.

After INSERT by TableAdapter VS 2005 I got exception
"NoNullAllowedException":
DataRow newSubsurface = subsurfaceDS.tSubsurface.NewtSubsurfaceRow();
newSubsurface["Name"] = "Item 1";
subsurfaceDS.tSubsurface.Rows.Add(newSubsurface);

The situation almost is the same where I try insert row manually by means
SQL Server Management Studio: I go to new row and write value to "field1",
go to "field2" and got... Exception: No retrived data (ID is Null)!
Row viewed only by "SELECT * FROM tSubsurface;" generated Management Studio
(region SQL) and the row is renew by calculated ID.

Why? Is this feature of SQL 2005 Express?

-----------
Looking forward to hearing from you soonest,
Alexander GORBYLEV

Somewhat near to this is on:

Only when I deleted default value, the rows are inserting

Alexander GORBYLEV

[quoted text, click to view]

And this field was as @-parameter with value NILL :-/