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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Cannot create indexed view in SQL 2000

Author  Topic 

partyfreak
Starting Member

2 Posts

Posted - 2001-01-08 : 05:41:26
This is the story.

I have 2 tables with a relationship.

I try to create a view, containing these 2 tables.

I can create an index on this view, but when trying to save
the view (I work in SQL Server Management Console), I always
get this errormsg :

ODBC Error : Index on MyView cannot be created because the view contains an imprecise expression in a join.

I need help!!! Please Please!!!

Johan Vanden Borre
The Knowlegde Factory
   

- Advertisement -