Insert into a table that has identity column

[madhavi123]

Hi All,

I have a to insert a set of rows into a table which is on some other server, and that table has an identity column which is also a primary key of that column.

I am getting the error 'Table 'myremoteserver.myremotedatabase.dbo.myremotetable ' does not exist or cannot be opened for SET operation' if the statement
SET IDENTITY_INSERT 'myremoteserver.myremotedatabase.dbo.myremotetable ' on
is written before the insert statement.

Also If I dont include that column in the select statement which is after insertion, I get the following error message "Insert Error: Column name or number of supplied values does not match table definition.
"

Can someone please help me how to solve this problem.

Thank you.

[kestrel]

I am moving this to the Forum.

--
Kestrel

[debasisdas]

Before inserting records ,please check table defination(structure) properly.

Both should match.

[jojo41300000]

Hi All,

I have a to insert a set of rows into a table which is on some other server, and that table has an identity column which is also a primary key of that column.

I am getting the error 'Table 'myremoteserver.myremotedatabase.dbo.myremotetable ' does not exist or cannot be opened for SET operation' if the statement
SET IDENTITY_INSERT 'myremoteserver.myremotedatabase.dbo.myremotetable ' on
is written before the insert statement.

Also If I dont include that column in the select statement which is after insertion, I get the following error message "Insert Error: Column name or number of supplied values does not match table definition.
"

Can someone please help me how to solve this problem.

Thank you.

It should match the number of parameters to insert with the number of columns in table.