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 |
|
Rocko
Starting Member
26 Posts |
 Posted - 2006-05-18 : 16:42:17
|
| Hi Friends,I would like to use Full-Text Catalogs and Indexes in my app. However my data is as a view not a table. However A full-text index must be defined on a base table; it cannot be defined on a view, system table, or temporary table … ([url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_80tv.asp[/url])So what is the best way to implement it? Should I create another table and schedule a procedure to update that table based on my view or? I will be happy if anybody share some experience.Thanks in advance! |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-18 : 20:44:53
|
| where is your base table located and why not use it? If you need full-text catalog, then, that will be your primary business requirement. Let us know if this is the real requirement. If it is, somehow, you have to use a base table since that is how full-text catalog work. Do you have enough space in the server? you can also create a catalog in the original server where your table is and create a view for your app.May the Almighty God bless us all! |
 |
|
|
Rocko
Starting Member
26 Posts |
Posted - 2006-05-18 : 20:57:22
|
| Yes it is a real solution. It is actually a view between two tables. I don’t have the data in one table. I’m using union in the view to combine them. Below is the view if it will help:CREATE VIEW dbo.ViewImagesASSELECT distinct (OrderLineItem.FileN), 'LLL' as 'Source'FROM OrderLineItem INNER JOIN Orders ON OrderLineItem.OrderID = Orders.OrderIDWHERE ( (OrderLineItem.Status = 'Shipped') OR (OrderLineItem.Status = 'Successful') ) AND (Orders.DateOrdered > '2004-01-01 00:00:00') AND (OrderLineItem.ServiceCode = 'ABC' OR OrderLineItem.ServiceCode = 'BCD') AND OrderLineItem.FileN > ''Unionselect fileN, sourcecode from sharedFiles |
|
|
|
|
|
|
Full-Text Catalogs and Indexes