SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Creating temp table in a different database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

7 Posts

Posted - 10/03/2012 :  16:45:28  Show Profile  Reply with Quote
I am trying to extract a part of data into a temp table on a different database on a separate SQL server. Here's the query for that:

SELECT [DB1].[dbo].T1 .Col1, [DB1].[dbo].T2 .Col1, [DB1].[dbo].T1 .Col2, [DB1].[dbo].T2.Col2
INTO [DB2].dbo.DB2
FROM [DB1].[dbo].T1 

It's not recognizing DB2 here. When I run this query under SQL Server Management Studio, it gives an error:

Database 'DB2' does not exist.

If I comment out the line2 in above query, it compiles and works fine.

Any idea on how to fix this problem?

The Chadinator

1974 Posts

Posted - 10/03/2012 :  16:52:00  Show Profile  Visit chadmat's Homepage  Reply with Quote
You need to have a linked server to the other server. How would SQL know what server you are talking about?

Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 10/03/2012 :  17:28:33  Show Profile  Reply with Quote
see this to understand what all you need to do to add a linked server


SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000