Sunday, March 25, 2012

copy db sql7 ->2000 newbie question

Hi,
I have a backup copy of a database in sql 7. I am copying it over to sql
2000 and then restoring it. There are 3 views that show up in both the table
and view section in sql 2000 but they are only in the view section in sql 7.
(sql 7 running on windows 2000 server/sql 2000 on windows 2003 server.) why
is that happening?
Thanks for any help with this. much appreciated!
kak37
On Jun 13, 10:12 am, kak37 <k...@.discussions.microsoft.com> wrote:
> Hi,
> I have a backup copy of a database in sql 7. I am copying it over to sql
> 2000 and then restoring it. There are 3 views that show up in both the table
> and view section in sql 2000 but they are only in the view section in sql 7.
> (sql 7 running on windows 2000 server/sql 2000 on windows 2003 server.) why
> is that happening?
> Thanks for any help with this. much appreciated!
> --
> kak37
Try refresh at databse level (EM) and check again
sqlsql

No comments:

Post a Comment