HI People,
I am searching for this option trustworthy, why it has to be Enabled before creating assembly in our database. I have tried trustworthy option with OFF i am getting below Error.
In Mirroring Asynchronous mode also we have to use this option some where while mirror server getting online.
Please suggest me what is the actual reason to use this trustworthy option.
Msg 10327, Level 14, State 1, Line 1
CREATE ASSEMBLY for assembly 'encdec' failed because assembly 'encdec' is not authorized for PERMISSION_SET = UNSAFE. The assembly is authorized when either of the following is true: the database owner (DBO) has UNSAFE ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem.
Regard's,
Thrilok,
SQL DBA.