View Full Version : Script to restore views


mmitchell
01-27-2006, 08:48 AM
I need to restore a bunch of views from an earlier date, so I went to a backup and generated a script for all the views that I need, but now when I run it in Query Anylizer I get erros about a view that is used in the view that I am trying to create, not being there.

Well, it will be when I get done running the script! How do I tell SQL Server to go ahead and build each view regardless of wheather it is there "yet" or not?

I have tried using the "script dependnecies" but that creates the scripts for tables and I don't want to touch my tables, they are all OK, I just need to remake all the views.