2 Replies Latest reply on Dec 9, 2006 1:03 PM by proxim00

    Full Text Index

    proxim00 Level 1
      I was looking around and I did not see and answer so I thought I would ask, does anyone know if you can do a full text index on a sql view? I have a view that is putting togeature a few tables and I want to search them but it keeps saying they have to be full text index enabled but sql2005 should have them enabled by default right? I was just wondering if you can do it on a view because the Tables do have it enabled.

      Thanks
        • 1. Re: Full Text Index
          Level 7
          proxim00 wrote:
          > I was looking around and I did not see and answer so I thought I would ask,
          > does anyone know if you can do a full text index on a sql view? I have a view

          "A full-text index must be defined on a base table; it cannot be defined on a
          view, system table, or temporary table."

          at least that's what the sql server 2000 BoL has to say.

          also enabling full-text indexing is just the first step. you have to define &
          populate it.
          • 2. Re: Full Text Index
            proxim00 Level 1
            Thanks Paul, I was thinking that was the case but I couldnt find any information online to confirm that.

            Thanks again.