restoring sql 7 to sql 2000 converts views to tables ???

I just did a restore of a database created in SQL 7 and it seems that
SQL Server 2000 converted all the views to tables, which is no good.
Anyone know of a fix for this?
Did you actually do a restore or did you use DTS or the Import/Export wizard
? I've not seen this behaviour on a straight database restore (in fact I
can't see how it would be possible) but I have seen it using DTS
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"alloowishus" <alloowishus@.yahoo.com> wrote in message
news:b3c62b19.0404140825.6c8d44b9@.posting.google.c om...
> I just did a restore of a database created in SQL 7 and it seems that
> SQL Server 2000 converted all the views to tables, which is no good.
> Anyone know of a fix for this?

restoring sql 7 to sql 2000 converts views to tables ???

I just did a restore of a database created in SQL 7 and it seems that
SQL Server 2000 converted all the views to tables, which is no good.
Anyone know of a fix for this?Did you actually do a restore or did you use DTS or the Import/Export wizard
? I've not seen this behaviour on a straight database restore (in fact I
can't see how it would be possible) but I have seen it using DTS
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"alloowishus" <alloowishus@.yahoo.com> wrote in message
news:b3c62b19.0404140825.6c8d44b9@.posting.google.com...
> I just did a restore of a database created in SQL 7 and it seems that
> SQL Server 2000 converted all the views to tables, which is no good.
> Anyone know of a fix for this?sql

restoring sql 7 to sql 2000 converts views to tables ???

I just did a restore of a database created in SQL 7 and it seems that
SQL Server 2000 converted all the views to tables, which is no good.
Anyone know of a fix for this?Did you actually do a restore or did you use DTS or the Import/Export wizard
? I've not seen this behaviour on a straight database restore (in fact I
can't see how it would be possible) but I have seen it using DTS
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"alloowishus" <alloowishus@.yahoo.com> wrote in message
news:b3c62b19.0404140825.6c8d44b9@.posting.google.com...
> I just did a restore of a database created in SQL 7 and it seems that
> SQL Server 2000 converted all the views to tables, which is no good.
> Anyone know of a fix for this?