I received an email outlining a restore problem. In attempting to restore a SQL Server 2000 master database onto a SQL Server 2005 as a user database, the
following error message appeared:
Retore failed for Server 'MyServer\MyInstance'.
There is already an object named sysnsobjs in the database
The solution is to restore a system database only to a SQL Server edition & version that are exactly the same as the source SQL Server.
Republished from http://www.sqlserver-dba.com.