The February 2002 issue of SQL Server Magazine, www.sqlmag.com, covers this.

>Hi All:
> I am think of upgrading my database from Sql 7.0 to Sql 2000. However, before I upgrade, I like to know would my views, stored procedures, user rights, security setups and table dependies be transfer to Sql 2000 from Sql 7.0 cleanly? Is there something that is not upgradeable to Sql 2000 from Sql 7.0? Is there O/S limitation in using Sql 2000? What are the positives of upgrading to Sql 2000 from Sql 7.0 and what are the negatives?
>Just to mention few.
>Thanks