Do you really expect me to type that myself in the db.. the link tells you how to generate the insert statements.

Also I forgot to tell you to include the...

Check out sp_addlinkedserver in books online.

Do you have multiple db files? Is the db being used and working?

Help us help you

Just create a test sp and try to recreate the code I build, that'll give you a better understanding of the task at hand... but beleive me, my wizard saved...

Sorry if I offended you but I don't like having my life thrown in the dirt.

Help us help you

No.

The command parameters are strong typed.

What are you complaining about, I probabely saved a full week of work here. Why aren't finishing the 2 minutes of work left and...

Always how it happens.

Does it work now?

Yes.

Good, let's keep it that way .

End of conversation if he has some good sens left in him.

You have 120+ parameters to pass... you can't just call the sp and not tell it what to insert in the tables.

Like my friend told me once... it's not what you said.. it's the accumulation...

What's the sp's supposed to return (sample data)?

Can you post the table definition, sampla data (insert scripts ONLY). Repost the update query that fails (make sure that the update fails with the data you send me). ...

That's why we must start them on the right track when we have a chance .