Msdn Sql Error 'msg 7391
Contents |
360 games PC games
Ole Db Provider For Linked Server Was Unable To Begin A Distributed Transaction.
Windows games Windows phone games Entertainment All Entertainment unable to begin a distributed transaction linked server 2012 Movies & TV Music Business & Education Business Students & educators
Returned Message No Transaction Is Active
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet ole db provider sqlncli10 for linked server returned message no transaction is active Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All the transaction manager has disabled its support for remote/network transactions Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
360 games PC games
Msg 7391, Level 16, State 2, Line 3
Windows games Windows phone games Entertainment All Entertainment sql server distributed transaction linked server Movies & TV Music Business & Education Business Students & educators
A Nested Transaction Was Required Because The Xact_abort Option Was Set To Off
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://support.microsoft.com/en-us/kb/306212 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/329332 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://dba.stackexchange.com/questions/30235/msg-7391-distributed-transactions-dtc-on-sql-server the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions https://sqldbpool.com/2009/11/10/msg-7391-level-16-state-2-line-23-error-while-running-linked-server/ Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn linked server from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Msg 7391, Distributed Transactions (DTC) on SQL Server up vote 2 down vote favorite This may be DBA related or developer related, I ole db provider honestly don't know. I have two Database servers: A: SQL Server 2005 (Trigger that uses DBMail on Server B) B: SQL Server 2008 R2 (DBMail configured) I have a table in Server A where email notifications are queued and I created an "after insert" trigger to execute sp_send_dbmail using Server B like so... USE SampleDB ALTER TRIGGER [dbo].[mail_inserted] ON [dbo].[tblEmailQueue] AFTER INSERT AS BEGIN declare @MailTo nvarchar(max), @MailSubject nvarchar(max), @MailBody nvarchar(max) -- Initialize vars select @MailTo=MailTo from inserted select @MailSubject=MailSubject from inserted select @MailBody=MailBody from inserted -- Send email via DbMail on ServerB exec [ServerB].msdb.dbo.sp_send_dbmail --this runs fine by itself, but not via trigger @profile_name = 'Test Profile' ,@from_address = 'noreply@test.com' ,@recipients = @MailTo ,@subject = @MailSubject ,@body = @MailBody END Here's where the weirdness begins that I need help with, mind you this seems to be a very poorly documented (or severely lacking thereof) feature. Now I can execute that last statement with some sample data and everything works just fine. But when I try to insert into the table like so... insert dbo.tblEmailQueue (MailTo,Mail