Post reply

Linked servers and views

  • April 23, 2004 at 6:19 am

    #162408

    What is the criteria for a view to show up under linked servers\views? My own user defines views does not appear when browsing linked servers. Why?

    Patrick Bohman

  • April 23, 2004 at 6:37 am

    #503968

    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.

  • April 23, 2004 at 6:56 am

    #503975

    How do I fix that?

  • April 23, 2004 at 7:03 am

    #503978

    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.

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

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