Hola, debes habilitar TRUSTWORTHY en la base de cuestion, si mal no recuerdo es algo asi como
ALTER DATABASE SET TRUSTWORTHY ON 2006/11/16, Pepe Ballaga (r) <[EMAIL PROTECTED]>:
Hola amigos por mas que trato no puedo crear un assemblie en mi BD que no sea de tipo safe, si le cambio las propiedades a extarnal access o unsafe me da el siguiente error y no se porque?. gracias ¿como puedo hacer para cambiar esto? TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for SqlAssembly 'compactar'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+SqlAssembly&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. ( Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE ASSEMBLY for assembly 'compactar' failed because assembly 'compactar' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS 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 EXTERNAL ACCESS ASSEMBLY permission. (Microsoft SQL Server, Error: 10327) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=10327&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------
-- ---------------------------------------------------- Microsoft MVP (Most Valuable Professional) SQL Server Orador Culminis (www.sqlgurus.org) -------------------------------------------
