Restoring a copy of a database

If restore a backup of a database to a database with a different name and
owner, do I have to recreate the views and re-apply permissions to the table
s
etc. As I far as I can see all the views are owned by the dbo, but the actua
l
database owner differs. From a SQL Server point of view I can look at the
database and all seems ok and I can run select's against tables and views.

You can change owner to a proper login using sp_changedbowner. And you can s
ync logins using
 sp_change_users_logi
n.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/


"Russell" <Russell@discussions.microsoft.com> wrote in message
news:3D20C46F-1DF4-4E28-BD69- 014ED8EFA270@microso
ft.com...
> If restore a backup of a database to a database with a different name and
> owner, do I have to recreate the views and re-apply permissions to the tab
les
> etc. As I far as I can see all the views are owned by the dbo, but the act
ual
> database owner differs. From a SQL Server point of view I can look at the
> database and all seems ok and I can run select's against tables and views.