February 21st, 2012, 04:56 PM
|
|
Registered User
|
|
Join Date: Oct 2009
Posts: 2
Time spent in forums: 34 m 55 sec
Reputation Power: 0
|
|
|
SQL 2005: In query, how to reference default catalog in linked server
How a number of environments on different servers and databases,
make a linked server object 'Target' that I change the datasrc on via a stored proc to 're-point' my scripts
what I want to be able to is to reference the default catalogue I set in my linked server via a query
like
Select * From LinkedServer.DefaultCatalogue.dbo.MyTable
using openquery() seems to be the only thing that will work so far but I want to avoid having to encapsulate my entire query as text
Any suggestions?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
