Glitch in moving SQL Server "Views" to new database.
I generated a script in SQL2000EM to "move" about 1000 views to a new server. OK with that.
Problem: Many (over 100) views fail to create due to the fact that some VIEWS are based on other VIEWS that have not yet been generated in the script. (for example: CREATE VIEW VIEW1 as SELECT * from VIEW2....VIEW2 does not (yet) exist).
I heard from someone to try using DMO to move the view, however not familiar with that.