Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Basu Hullur How to get the number of rows from a table reside in a linked server as fast as possible. RE: How to get the number of rows from a table reside in a linked server as fast as possible.

  • January 20, 2009 at 4:30 am

    #929593

    Or you could do something like....

    SELECTi.rows

    FROM[linkedserver].[linkeddb].dbo.sysindexes i

    INNER JOIN [linkedserver].[linkeddb].dbo.sysobjects o ON i.id = o.id

    WHEREo.name = 'HereGoesTheTable'

    AND i.indid < 2

    --Ramesh