Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

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

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Invalid object name 'Asterisco.dbo.home_planes_mov
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alejo46
Posting Yak Master

Colombia
157 Posts

Posted - 12/11/2013 :  12:36:30  Show Profile  Reply with Quote
Good morning,
I've trying to analize a DTS which extrac some data from one SQLSERVER
to another SQLSERVER by menas of a Transfotmation Task (Thick arrowwhich contains this query:

SELECT COD_PLAN, ISNULL(VLR_PREFERIDO_INTERNAL, 0) AS VLR_PREFERIDO_INTERNAL,
ISNULL(VLR_9PREFERIDOS_ACT, 0) AS VLR_9PREFERIDOS_ACT
FROM Asterisco.dbo.home_planes_movistar_actual
i copy this query and run in query analizar but yields me an error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Asterisco.dbo.home_planes_movistar_actual'.

The datasource is a server call SQlTEST and its DB is called Asterisco (what i know this query is taken from the source SQLSERVER) but not locally thats why it yiels that error:

How am i supposed to run the same query in the local server and simulate im running this query locally ?
THanks in advanced ?

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 12/11/2013 :  12:40:12  Show Profile  Reply with Quote
You cant run and check this query in local server unless you've a database by name Asterisco with table home_planes_movistar_actual in it.You need to get access to remote server SQlTEST for that, register it in enterprise manager and then connect to it through query analyser

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next 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.04 seconds. Powered By: Snitz Forums 2000