You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.

Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:

SELECT <col_list> FROM LinkedServer...TableName;

You should be saying:

SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;




[quoted text, click to view]

You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.

Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:

SELECT <col_list> FROM LinkedServer...TableName;

You should be saying:

SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;




[quoted text, click to view]

Hello:
I am trying to create linked server ( another SQL Server) to my SQL Server,
using Enterprise Manager, but new alias pointed me only to master database.
How can I change settings of the link server to get access to pubs database?

Thanks,
GB