ramana3327 (8/27/2015)
Hi,Under sql server errors, I am seeing frequently
The activated proc 'sp_name' running on queue 'TestDB.dbo.SP_name' output the following: 'The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.'
What does it mean?
Is this something serious issue? Do we need to worry about that sp?
How about some details??? The code for this procedure would be a nice addition to your post. I am guessing you probably have some level of "nested" transaction going on. Also, you really should avoid the SP_ prefix for procedure names, or even better drop the prefix entirely. That prefix is reserved by MS for system procedures and can cause performance and other challenges if there is a name collision.
_______________________________________________________________
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/