Querying remote table

• evaleah

  Ten Centuries

  Points: 1372

  More actions

  September 22, 2005 at 4:18 pm

  #91323

  I want to be able to query a table on a remote server and then run an xp on the local server.

  I have tried:

  select emailid from [remote].[dbname].dbo.tb_email

  It keeps telling me that I have more than the max number of identifiers.  Is there a way to do this?  Thanks.

  Eva

• evaleah

  Ten Centuries

  Points: 1372

  More actions

  September 22, 2005 at 4:22 pm

  #592437

  Never mind.  I am a doofus.  My issue was actually later in the query and not worth mentioning....