Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-07-12 : 05:32:59
|
| how do i call a sql statement that refers to a a free text index on another server?If I try it, I get:Server: Msg 7639, Level 16, State 1, Line 1Cannot use a full-text predicate on table '' because it is not located on the local server. |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-07-12 : 05:56:52
|
| I created a parameterized function that returns a table. And then I made a view point to it. But that would not work in a mutli-user/connection environment because I would have to alter the view each time the parameter changed. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-07-13 : 03:27:21
|
| ah, that's a "can't be done" then. Great. Made a significant investment into free-text indexing only to find this limitation out significantly further down the line. Does BOL mention this limitation? I can't remember reading it... |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-07-13 : 03:53:29
|
Dont know whether this helps and dont know whether there any issues with doing this. I have just tried this on 2 of our servers and it works so it maybe an option for you1. Setup your linked server (the server with free text indexing) on your "other" server and in the link server options "check" the RPC out2. Create a SPROC on the linked server to return a record set using the free text predicates3. From the other server execute the sproc EXEC LinkServer.DBName.dbo.YourSproc 'SearchString'Hope that helpsAndyBeauty is in the eyes of the beerholder  |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-07-13 : 07:28:07
|
| Thanks AndyThat did the trick! |
|
|
|
|
|
|
free text