Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-17 : 10:01:29
|
| sk writes "How to convert autonumber in Access to unique identifier in SQL server.Set the identity to yes but still have the error:Cannot insert the value NULL into column 'ID', table 'db.dbo.Files'; column does not allow nulls. INSERT failsThanks" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-07-17 : 10:38:43
|
| It appears you have some nulls in your source data.If you want to overwrite SQL's identity with the one from Access, you must set the identity insert.See SET IDENTITY INSERT in BOL. |
 |
|
|
|
|
|
SQL