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 |
|
DRAGON
Starting Member
13 Posts |
 Posted - 2009-01-20 : 07:11:31
|
| Dear all,I'm using Fulltext search for my project. I created a view. From this view, i want to define fulltext search for this View. But this view i cannot create a unique index with one column.Now i want to add a unique column for the view, but i don't know how to do it.Please suggest me a way to resolve the problem with fulltext search.Many thanks to allLuatVVdragon |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-20 : 07:25:19
|
| I'd also suggest that you have the identity or unique column managed on the application end since the above methods might be slow in case you are dealing with large volume of data. |
 |
|
|
DRAGON
Starting Member
13 Posts |
Posted - 2009-01-20 : 08:33:32
|
| Many thanks for your help, but another prolem i get that "Cannot create index on view 'View' with left, right, full, outer join, Text, NText, Image data"do u have any way to over come this problem.Many thanks to all.LuatVVdragon |
|
|
|
|
|
|
how to create an index column for view (Fulltext)