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.
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.
