Upgrading SQL 2000 to SQL 2008R2 -- Most Views Do Not Show Query Result
Posted on 2014-07-18
I am trying to upgrade a database from SQL 2000 to SQL 2008R2. I tried the Copy Database Wizard, but it errors out. Next, I tried the backup-restore method.
Most things seem to be fine with the backup-restore method. I can query tables, see the stored procedures, logins, and so on. However, most of the Views do not give any output when I run:
SELECT TOP 1000 [ViewName]
From two to three of the Views show output after running the above SELECT, but the rest do not show anything.
How can I get these Views upgraded from SQL 2000 to SQL 2008R2 Enterprise Edition. This is a side-by-side upgrade, and not an in-place upgrade.