I solved my problem by re-writing the view definition.

I experimented yesterday with different versions of the same select. The one that seems to make the difference is the ProjectID column...

The view definition is the same as the select-statement, except that I have added 'ProjectID=123 and phcode like '%abc%' in the select statement.

That's what surprises me. That running a query...

Thanks guys for your help.

Here it comes. I have stripped off some of the columns for readability, but the structure is the same.

I tried to include the execution plans but...

Do you mean adding an index on the view? From the manual it says that indexed views are not well suited when you have frequent updates. Although the view is...

Thanks for your response Allen.

Yes, after the upgrade I re-created all the views. As well as all the procedures and triggers.

/Minh

Thanks for the excellent article. One thing I do miss, as with other upgrade resoruces/articles I have read so far, is that the upgrade is entirely focused on the server...

Thanks for your advice guys/gals. My first upgrade choice will probably be install 2000 over 7 (default instance). I will of course have to test it out first before going...

Hi once again,

I overlooked the simplest step before viewing other possibilities. That is of course to run DBCC CHECKDB.

After that the procedure could be created without problem.

/Minh

Hi again,

Some clarifications,

1) The two databases in question are identical, at least on object level. I have confirmed this running a database compare in Power Designer.

2) Since 1) is...