Linked servers and views

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

xyz SSCommitted Points: 1603 More actions · Answer 1

query your view:

select *

from [servername].[databasename].[dbo].[viewname]

your view does not appear, because it's not in the default database for linked server login.

ensten Valued Member Points: 57 More actions · Answer 2

Valued Member

Points: 57

April 23, 2004 at 6:56 am

How do I fix that?

xyz SSCommitted Points: 1603 More actions · Answer 3

it's not a matter if you can't see your view, as long as your view existing and you can query it.

if it's a matter, try to change the default database of the login that was in your linked server.