Problem with user-defined functions in SQL Server 2008
-
Hi All Would you please help me, I have a stored procedure that calls a function within it. It is working fine when pointing to production database, but when I change my connection to point to QA it raises an error. I have copied both the stored proc and the function from production to QA but still. The error that I get is "A .NET Framework error occurred during execution of user-defined routine or aggregate" I am using SQL Server 2008 full version. Thank you in advance for your assistance.
MP
-
Hi All Would you please help me, I have a stored procedure that calls a function within it. It is working fine when pointing to production database, but when I change my connection to point to QA it raises an error. I have copied both the stored proc and the function from production to QA but still. The error that I get is "A .NET Framework error occurred during execution of user-defined routine or aggregate" I am using SQL Server 2008 full version. Thank you in advance for your assistance.
MP
Are you getting the error in the client app or actually in the stored procedure. The dot net error indicates either the client has a problem or you have the CLR integration in SQL server turned on X| . Either way without more detail cannot help.
Never underestimate the power of human stupidity RAH
-
Are you getting the error in the client app or actually in the stored procedure. The dot net error indicates either the client has a problem or you have the CLR integration in SQL server turned on X| . Either way without more detail cannot help.
Never underestimate the power of human stupidity RAH
-
Hi RAH Thanx for the reply. I actually get this error even when I manually execute the stored procedure in SQL Server.
MP
Then I would think the function is a CLR function and there is a bug in there. Never having used the CLR in SQL Server I do not know how you debug such a beast.
Never underestimate the power of human stupidity RAH