10 oct 2007

Index Server & SqlServer

 Sample

SELECT Q.FileName, Q.Size, Q.DocAuthor
FROM OpenQuery(FileSystem,
              'SELECT FileName, Size, DocAuthor
               FROM SCOPE()
               WHERE CONTAINS(''"SQL Server"
                                NEAR() text'')
                 '
             )   AS Q


Select * from OpenQuery(FileSystem, 'Select DocTitle, vpath, Filename, Size,
Contents, characterization, PATH, URL, A_Href, rank, write
from server.TestCatalog..Scope()
where FREETEXT(Contents, ''texto'') AND Rank > 0 order by rank desc,
write desc')



EXEC sp_addlinkedserver FileSystem,
  'Index Server',
  'MSIDXS',
  'Web'



select doctitle, vpath, size, create from
RemoteServerName.RemoteCatalogName..Scope() where contains('microsoft')

No hay comentarios:

FeedCount

analytics

 
sfrede