Home Forums SQL Server 2008 Security (SS2K8) Having Trouble Granting Access to a Table for a User Through Linked Server RE: Having Trouble Granting Access to a Table for a User Through Linked Server

  • I don't know exactly what you mean with "see", but you mean what you see when you expand nodes in SSMS, please attempt to run queries from a query window instead, so we know what is going on.

    When you access a remote instance through a linked server, there is no difference from when you access the remote server directly. That is, your local server is just another client as far as the other instance is concerned.

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