We have a SQL Server 2000, it has a database that we will restore to SQL Server 2008 R2.
We have created a couple of VIEWs against some tables in this database.
I am wondering after I restore the database to SQL Server 2008 R2, will the VIEWs be also restored? If not, how can I make the VIEWs showing up in SQL Server 2008 R2 without re-creating them manually?
Thanks in advance!