Using the full name server.database.owner.table...

[ccuster]

I have been using linked servers for over a year on this particular stored procedure that generates a temporary table from a select as such:

select * into #temp from server.database.owner.table
I get an error message:
Server: Msg 7353, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.

I then connected to the server itself and ran the same query: select * into #temp from server.database.owner.table
I get an error message:
Server: Msg 3910, Level 16, State 1, Line 1
Transaction context in use by another session.

When I am on the server I run the select as:
select * into #temp from table
and it works fine.

Has anyone ran into this before or has any advise?

TIA

 

[ccuster]

For anyone's interest, I solved my own problem. The day before I added a column name to the table, thus the sysobjects did not reflect this.

Solution: copy table to another name,
check to make sure new table is there,
drop old table rename new table.

Fun out of the sun with MS