Post reply

Link server select statment

  • February 9, 2011 at 11:51 am

    #98061

    I need to get data from linked server, what is the correct syntax for that, this is what I do,but this is not corect:

    SELECT *

    FROM Linkservername..databasename.tabel name

    Thank you

  • February 9, 2011 at 12:14 pm

    #1284749

    Krasavita (2/9/2011)

    I need to get data from linked server, what is the correct syntax for that, this is what I do,but this is not corect:

    SELECT *

    FROM Linkservername..databasename.tabel name

    Thank you

    You need a username:

    SELECT * FROM linkedservername.databasename.username.tablename

    Probably the username is "dbo", most people seem to make all tables (and other objects) belong to that user.

    Tom

Viewing 2 posts - 1 through 1 (of 1 total)

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