sysremote_indexes

• ALI-408105

  Say Hey Kid

  Points: 709

  More actions

  February 13, 2007 at 12:38 pm

  #172251

  How to select data from sysremote_indexes system table?

  I get following error.

  /*-----------------------------

  select * from dbo.sysremote_indexes

  -----------------------------*/

  Server: Msg 201, Level 16, State 7, Line 1

  Procedure 'dbo.sysremote_indexes' expects parameter 'ServerName', which was not supplied."

• kb

  SSC Journeyman

  Points: 85

  More actions

  February 15, 2007 at 8:18 am

  #689967

  SELECT * FROM master.dbo.sysremote_indexes('YourLinkedServer','RemoteDatabase','dbo')

  Tom

  http://kbupdate.info/