Getting Failed to create AppDomain "mssqlsystemresource.sys[runtime] in profiler RRS feed

  • Question

  • I am getting this in profiler. Can some one tell me what is the reason.

    Msg 6517, Level 16, State 1, Procedure sp_columns_100, Line 138

    Failed to create AppDomain "mssqlsystemresource.sys[runtime].76".

    Method's type signature is not Interop compatible.

    declare @p1 int set @p1=1073741836 declare @p2 int set @p2=180150029 declare @p5 int set @p5=16 declare @p6 int set @p6=1 declare @p7 int set @p7=-1 exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'SELECT [attach_id],[attach_desc],[status_cd],[unique_key] FROM im_attach_mstr ORDER BY 1',@p5 output,@p6 output,@p7 output select @p1, @p2, @p5, @p6, @p7

    • Changed type ArthurZModerator Wednesday, August 15, 2012 3:21 AM The reflect intent
    Tuesday, July 24, 2012 9:08 AM

All replies

  • Most likely this is due to the sqlclr using the wrong .Net Framework version.

    Must be fixable by visiting

    Arthur My Blog

    Wednesday, August 15, 2012 3:26 AM