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')
10 oct 2007
Suscribirse a:
Enviar comentarios (Atom)
analytics
Etiquetas
- .NET 2.0 (15)
- ADM PROYECTOS (3)
- AJAX (2)
- Ale Sfrede (1)
- alesfrede (27)
- Arch (3)
- chrome 2.0 (1)
- chrome extension (1)
- CSS XML HTC (2)
- extension (1)
- google (1)
- google chrome toolbar (1)
- init (1)
- News (3)
- realtime (1)
- Scripting (4)
- sfrede (1)
- SQL Server (3)
- translate (1)
No hay comentarios:
Publicar un comentario