August 8, 2013 at 6:04 am
Friends,
We are getting the error mentioned below whenever we are executing a function in the DB.
Failed to create AppDomain "CAC_HL7_1.dbo[runtime].28871".
Exception has been thrown by the target of an invocation.
The same function is present in another SQL Server Instance and it is getting executed without any issues.
Please help me in identifying what exactly the issue is and the fix for the same.
August 8, 2013 at 7:43 am
MuraliKrishnan1980 (8/8/2013)
Friends,We are getting the error mentioned below whenever we are executing a function in the DB.
Failed to create AppDomain "CAC_HL7_1.dbo[runtime].28871".
Exception has been thrown by the target of an invocation.
The same function is present in another SQL Server Instance and it is getting executed without any issues.
Please help me in identifying what exactly the issue is and the fix for the same.
Can you post some details? Let's start with the function.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 8, 2013 at 4:01 pm
Can you also post the output of "SELECT @@version"
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply