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 |
|
ZenRoe
Starting Member
14 Posts |
 Posted - 2008-11-04 : 08:26:58
|
| Good day all,I got a view which does have a clustered unique index. Is it somehow possible to have a primary key constraint on such a view ? Yeah, you wonder why I would need that. Reason is, I got a fulltext search engine (Boolware). It seems, that it is only possible to index objects which have a primary key .... I use SQL Server 2005. Any help is appreciated.Peter |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-04 : 08:47:18
|
| You can't add a primary key constraint to views.full text index the underlying table._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-07 : 10:55:41
|
| If you are NOT using SQL Server 2005 Enterprise Edition, then check if you are using the with (noexpand) hint. The optimiser will not use the index in the indexed view unless you specify the hint unless you are using Enterprise version. |
|
|
|
|
|
|
create a primary key on a view