Link Server Script

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  May 15, 2008 at 9:04 am

  #815961

  Ooops, for some reason it omitted the parameter to the sp.

• mike-511834

  SSC Enthusiast

  Points: 166

  More actions

  May 15, 2008 at 9:18 am

  #815970

  I was able to find an equivalant for

  select *

  from master.dbo.SYSREMOTE_TABLES (

  'lnkservername',

  NULL,

  NULL,

  NULL,

  NULL )

  this returns the same dataset in 2005 and 2000.

  sp_tables_ex 'lnkservername'

  It returns the listing of tables from the link server.

  thanks again everyone.

  This has helped me get back to coding and getting my project back on track...