CREATE ASSEMBLY报错
CREATE ASSEMBLY [xxx]
FROM 'D:\Microsoft SQL Server\xxx'
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO
Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 62
Object 'testDB' does not exist or is not a valid object for this operation.
testDB是备份还原出来的,我已经把现有的登录名name1指向了testDB,
设置name1为testDB的db_owner。
------解决方案--------------------孤立帐户的问题,使用sp_change_users_login
http://www.cnblogs.com/13590/archive/2007/09/28/909643.html
------解决方案--------------------还原之后账号没有属主数据库