• Any particular reason you expect this to work in the first place?

    From where I sit, I can only encourage you to check that

    1) You have spelled the database name correctly.

    2) The view is actually in the dbo schema.

    3) You have spelt the name of the remote view correctly.

    4) The view does actually exist in this database.

    5) Your login is permitted to access the database in the linked server.

    6) And your database user has permission to access the view.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]