note 44033 added to ref.com

If you want to use ms indexing server by querying it from ms sql server in a stored procedure with parameters you can do the following: 1.) Create the Catalog named 'myIndexServer' in indexing server 2.) execute addLinkedServer in query analyzer EXEC sp_addlinkedserver @server = 'myIndexServer', @srvproduct = 'Index Server', @provider = 'MSIDXS', @datasrc = 'myIndexServer' GO in case myIndexServer already exist choose another name or delete it (be carefull) EXEC sp_dropserver myIndexServer GO 3.) Write the following string in query analyzer declare @sql varchar(1000) declare @searchFor varchar(400) set @searchFor = 'phporsomething' set @sql =' SELECT Path, Filename FROM OPENQUERY( pmsIndexServer, ''SELECT Path, Filename FROM pmsProtokollAnhaengeIndex..SCOPE() WHERE CONTAINS( '''''+@searchFor+''''' )'' ) AS dres' -- end of long sql-string exec (@sql) Attention 5 times ' !!! 4.) Execute the string (F5) 5.) Create a simple stored procedure and copy the string from step 3. Make @searchFor an parameter of your sp 6.) You are done, lean back, enjoy and relax To contact me remove the fruits. ---- Manual Page -- http://www.php.net/manual/en/ref.com.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+44033 Delete -- http://master.php.net/manage/user-notes.php?action=delete+44033&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+44033&report=yes Search -- http://master.php.net/manage/user-notes.php