Create a table using a linked server?

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  September 8, 2010 at 7:37 am

  #237972

  Is it possible to test if a table exists on Server "B" when running a query on Server "A"? If the table does not exists, how can it be created via a linked server?

  Here's what I'm actually attempting to do:

  I have a temp table on Server "A" that needs to be matched up against a table on Server "B". The query via linked server runs terribly slow. If I could find a way to place the data from the temp table onto Server "B", and then run an OpenQuery, I could achieve a performance gain.

  Any suggestions?

  thanks in advance,

  pete

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  September 8, 2010 at 7:39 am

  #1217930

  you need to create the linked server first.

  then using linkedservername.databasename.dbo.tablename

  you can select/alter/create if the account have enough permission which you configured on linked server to connect

  ----------
  Ashish