• Terrie, be careful when copying views in this manner.

    If you are copying a view from one database to another, and the tables (and data) already exist in the destination, then copying the view with data will replace the data in the tables in your destination with the data from your source.  If you specify to not copy the data, then the rows in the tables in your destination that the view will reference will be deleted.

     

    Confusing? yes.

    Instead, execute the script generated in the properties of the view (from your source) on the destination.


    Enjoy!

    A Brown

    Manage all of your backups in one simple job using this script.