Re: Can't Create Asymmetric Key

Hello randy1200,

I believe I was able to create the clr stored procedure in visual
studio, set 'clr enabled' on the server, create an assembly, create an
sp based on the external name, and finally EXEC it from T-SQL to call
it. When I call it, I get the System.Security.HostProtectionException
below.

Here's the URL for an article I wrote to help with this kind of thing. Its the same idea the BOL covers, but in more tutorial fashion.

http://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


.

Relevant Pages

  • Re: can any application isten to a particular port on WM 6.0 devic
    ... running on any other server can write data on that port at any point of time. ... EventsArchitecture GeneralArchitecture, Tools, and Process for ISVsASMX Web ... Studio Team SystemHD DVD Interactivity AuthoringHealthVaultHealthVault Data ... DevelopmentWindows Desktop Search HelpWindows Error Reporting for ISVsWindows ...
    (microsoft.public.pocketpc.developer)
  • Re: String manipulation - taking one long csv string and putting into separate record fields
    ... From what I can work out, it looks as if the script is taking ... "%2147746132" from the computer VPN-01 when attempting to activate the ... computer VPN-01 when attempting to activate the server: ... EXEC xp_startmail ...
    (microsoft.public.sqlserver.programming)
  • Re: Replicating database schema changes in "daisy chain" situation
    ... create database central ... exec sp_replicationdboption 'central','merge publish','true' ... SQL Server B> is installed in another country and replicates key master data from server A.> MSDE Instance C replicates with Server B to receive this master data as well> as merge data that is shared only between B and C. ...
    (microsoft.public.sqlserver.replication)
  • Re: Script to delete backup files which are 7 days old
    ... you might want to know that the sp_smtp_sendmail and xp_smtp_sendmail have been used for this purpose by many many people on SQL Server 2000. ... DECLARE @DeleteFiles NVARCHAR ... SELECT 'exec xp_cmdshell ''DEL "' ...
    (microsoft.public.sqlserver.tools)
  • RE: connect to remote sql server in business Intelligence Development
    ... server in SQL Server BI Studio, ... As you said that connecting through SQL management studio works, ... I suggest you also try connecting other remote SQL Server ...
    (microsoft.public.vsnet.general)