Moving a Temp table to local server

So, I am still attempting to get my local server and the big server to cooperate. When I try to move a temp table to the local server (where I have import/export rights), I get the following error:

/*————————
USE COPD
GO

SELECT *
INTO COPD.dbo.InpatientStay
FROM [BIGSERVER].dbo.##COPDInpatientStay;
————————*/
Database name ‘BIGSERVER’ ignored, referencing object in tempdb.
Database name ‘BIGSERVER’ ignored, referencing object in tempdb.
Msg 208, Level 16, State 0, Line 4
Invalid object name ‘##COPDInpatientStay’.

Off to google this error…

(COPD is a database on my local machine.)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s