Re: iterate/loop indexing services files



Thank you for your replies. I will try them tonight. I just need to run
this once so performance isn't a big deal.

Do the queries require SQL Server? I am using the ixsso objects.

I looked all over for this answer.

--AC

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uelDWyP%23GHA.360@xxxxxxxxxxxxxxxxxxxxxxx
try this

select path,filename from webCat..scope() where size >0'

where my catalog name is webCat
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"AC" <no@xxxxxxx> wrote in message
news:el$h5cK%23GHA.5092@xxxxxxxxxxxxxxxxxxxxxxx
How can I loop through or get a resultset with all files in an indexing
services catalog?

Is there a way to make the returning recordset contain all records?

I want to go through and grab the FileIndex from all files. The files
are static so I don't have to worry about the value changing.

Thanks in advance

Follow-ups to microsoft.public.inetserver.indexserver



.



Relevant Pages

  • Re: FTS capabilities + questions
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ... The queries themselves against the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full-text searching component
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ... What is the recommended process to install full-text searching ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Merge Replication Error: "The Process could not enumerate changes at the Subscriber"
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.replication)
  • Re: FTS 2005 system exception c0000005 every few seconds
    ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Standard Edition vs. Enterprise Edition
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)

Loading