code_junkie

Creating a fulltext index on a view in SQL Server 2005

Nov 12th, 2011
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. CREATE FULLTEXT INDEX ON [dbo].[ProductSearchView](Id, Field)
  2. KEY INDEX PK_ProductSearchView
  3. ON FullText WITH CHANGE_TRACKING AUTO;
  4. GO
  5.  
  6. CREATE FULLTEXT INDEX ON [dbo].[ProductSearchView](Id, Field)
  7. KEY INDEX PK_ProductSearchView
  8. ON FullText WITH CHANGE_TRACKING AUTO;
  9. GO
Add Comment
Please, Sign In to add comment