Sql Server 2008 error : Error occured while executing saveText. The current transaction cannot be committed

Hi SQL Server 2008 Enterprise Edition : This error pops up once in few months and goes away.There is a sproc which inserts/updates data on a tableA(column1 int,column2 text datatype). There is a trigger on this tableA which inserts data in a different database in another tabletableB(column1 int,column2 varchar(max)). Most of the times this sporc runs fine but fails at timeswith the below error.There is no open transaction when I do a dbcc opentran.Sql server logs has no trace on this.The only fix I found is restart sql server services and this goes away.I tried to google this error but have no luck so far.Thank youError:System.ApplicationException: Error occured while executing saveText. The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.The statement has been terminated.. Parameters: ownerId=46373664 ---> System.Data.SqlClient.SqlException: System error. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at USATodayDotCom.MidTier.CMSGatewayServers.Components.ContentMgr.Dal.saveText(Int64 ownerId, String text) --- End of inner exception stack trace ---