Can anyone help me ?

I am using the DTS wizard/Import and using the option "Copy objects and data between SQL Server databases" and "include all dependent objects"

If you have more columns like:

CREATE TABLE test

(

ID  Int Identity (1, 1)

Name varchar(50)

)

Go

you can:

insert into test (Name) values ('John')

if you don't put a column in the first pharentesis it will...