February 21st, 2012, 04:56 PM
-
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?