CLR Stored Procedures doesn't work

Discussion in 'Databases' started by mjsw, Dec 24, 2009.

  1. I can deploy my SQL Server Project to the database and it's all fine, but I can't run my stored procedure, I'm getting error:

    Msg 6263, Level 16, State 1, Line 4
    Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

    Why do you allow to put my assembly in the DB if I can't run it? Or is there a way around this?
     
  2. Ray

    Ray

    CLR is not enabled on the SQL server. This compromises security on the SQL server. If you need to run any VB scripts against the database try running it as a ASP.Net application and have it connect to the databae via connection string and call it from there.
     

Share This Page