At my last job my dev team supported a Financial LOB VB5 application that used a SQL Server 6.5 database, and ran on and XP Pro machine. We had to...

I always wear business casual at work. Jeans just don't do it for me in the work place. Call me old school, but when I am at home...

Well, I cannot tell you what's different but I just tried this:

INSERT INTO [DEV001\SQL2005DEV].myDatabase.dbo.myTable

and it worked. "dbo" has always been present so that is not a change.

SELECT* from DEV001\SQL2005DEV.myDatabase.dbo.myTable returns:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '\'.

Yes, I have run the insert on it's own without the server name, just the database name, and it works correctly.

Yes, it's linked

Same her, I have to make all my fields varchar to get the bulk insert to work. Otherwise I get a type mismatch error too. I would prefer to...

That helps. It's one of those things I will need to 'see' work to 'get it'.

Thanks for the feedback.

I think I am missing something basic here jcrawf02.

How do I iterate over the temp table to retrieve the temp table id value? In .NET code i...

Yup, db admin is setting up linked servers. What I need to figure out is how to write the UPDATE statement in the stored procedure....update from the temp table...

One of the fields in the .CSV file that is BULK INSERTED to a temp table stores a key, call it "theID" to a lookup table where I can select...

"since it appears the databases exist on the same server, you could do this:"

They do not, they exist on 3 different servers.

Each row in the temp table will...

So my next challenge is this. The sql table that gets updated in the above UPDATE exists in 3 different databases. The temp table stores an id value...

Bingo, thanks

As a developer I only bring back the fields I want/need.

I can see your colleagues point though if they are doing some kind of code generation where classes/data...