How to add record on linked server

Question

How to add record on linked server

chris92mars

SSC Veteran

Points: 228
More actions
December 22, 2015 at 9:02 pm

#307247

I tried to add a new record on the linked server but it fail.
The Errror is Column Name or number of supplied values does not match the table definition.
I did not put the value for identity column, i just skip the column.
Should I put the value for identity column? but if I put, i hit another error, the error is the user did not have peromission to write to the column.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

chris92mars (12/22/2015)
I tried to add a new record on the linked server but it fail.
The Errror is Column Name or number of supplied values does not match the table definition.
I did not put the value for identity column, i just skip the column.
Should I put the value for identity column? but if I put, i hit another error, the error is the user did not have peromission to write to the column.

Can you post your statement please Chris? It will reduce the number of guesses required to find the answer.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

You can't include the identity column name in the column name list or the values you want to insert. You also need permission to insert rows into the table. Please post your insert statement for further help.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions