This is kinda weird... I remember that I once had this, but can't remember the cause or solution...
In a CLR stored procedure (SQL Server 2005) of mine I get a ThreadAbortException. All the details I have are the following:
System.TypeInitializationException: The type initializer for 'Microsoft.SqlServer.Server.SmiContextFactory' threw an exception.
---> System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown. --- End of inner exception stack trace ---
at Microsoft.SqlServer.Server.SqlDataRecord.get_SmiVersion() at Microsoft.SqlServer.Server.SqlDataRecord..ctor(SqlMetaData[] metaData) at StoredProcedures.GetCases(SqlString p_URL, SqlInt32 p_CaseNumber, SqlInt32 p_SubCaseNumber, SqlString p_AutoRegNumber, SqlDateTime p_AccidentDate, SqlString p_PersCodeRegNum, SqlString p_Name, SqlString p_AccidentPlace, SqlInt32 p_PolicyNumber, SqlString p_CadastreNumber, SqlInt32& p_ErrCode, SqlString& p_ErrMsg)
The procedure just calls an XML web service and returns the result as a resultset. It seems that the web service call happens correctly and in full. Any ideas?