Home > Cannot Use > Cannot Use Save Transaction Within A Distributed Transaction

Cannot Use Save Transaction Within A Distributed Transaction

Thanks, Micky Tuesday, January 03, 2006 9:52 PM Reply | Quote 0 Sign in to vote I posted some of this same information to the microsoft.public.sqlserver.server group. I get the following error: Error 627: Cannot use SAVE TRANSACTION within a distributed transaction Since this is something the wizard is doing and I can't see the code, I'm having References: Error when creating replication: Cannot use SAVE TRANSACTION within a distributed transaction From: SammyBar Prev by Date: Re: Trans Repl with Immediate Update Subscriber Next by Date: Re: Distributed transactions I will be interested to hear if you solved the problem. http://homeshareware.com/cannot-use/cannot-use-save-transaction-within-a-distributed-transaction-filenet.html

Help in backup of data 3. You may download attachments. Existing properties can be added. All servers are running version 7.00.699 (SP1), on NT Enterprise SP4. view publisher site

Teenage daughter refusing to go to school Why are password boxes always blanked out when other sensitive data isn't? Environment P8 Content Engine 4.5.1 Microsoft SQL Database Database Replication enabled Diagnosing the problem Error message seen while adding new property to the document class: ErrorCode: 627, Message: 'Cannot use SAVE You cannot edit other posts. Sammy .

Close this window and log in. Please could someone help me? OLAP Error: Cannot save objects inside a DSO transaction 13. save transaction sp_xxxxx endwhich allows us to rollback to the savepoints, if necessary.These have worked fine for a number of years.

cannot save transaction within a distributed transasction??? 10. Mine was not caused by altering the table though. You cannot delete other events. Just for giggles, I set the transaction level for the object in COM+ to supported instead of required, and this seemed to help on some of the objects...but this is not

The subject is "SQL 2005: Error with Trigger" Tuesday, January 03, 2006 10:13 PM Reply | Quote 0 Sign in to vote Thought I would post one additional link. Already a member? You cannot edit other events. Post #247602 Mark HarrMark Harr Posted Sunday, January 1, 2006 11:45 AM Ten Centuries Group: General Forum Members Last Login: Monday, October 3, 2016 12:48 PM Points: 1,333, Visits: 190 You

You cannot delete your own events. https://groups.google.com/d/topic/microsoft.public.sqlserver.replication/hTPo4RvGqxk exec sp_configure 'show advanced' ,1goreconfigure with overridegoexec sp_configuregoIf so do you know why it is enabled and is it possible to turn this off?To turn it offexec sp_configure 'remote proc trans',0goreconfigure All Forums SQL Server 2000 Forums SQL Server Development (2000) SAVE TRANSACTION in DISTRIBUTED TRANSACTION Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-09/12/2005: Terms of Use.

After that the problem disappeared. Making a change in that sp makes it so the error goes away. You cannot post events. You cannot send private messages.

Registration on or use of this site constitutes acceptance of our Privacy Policy. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Check This Out What is the total sum of the cardinalities of all subsets of a set?

You cannot post JavaScript. Are you aComputer / IT professional?Join Tek-Tips Forums! So unfortunately, it seems you need to either drop the bounding ACID transaction, or change the SPROC on the remote server so it doesn't use SAVEPOINTs.

On all three (pub, sub, distr) there is plenty of disk space and RAM.

Go back to SQL 7 (not SP1)?? The code is like this: insert <> (fund, strat, clr, [id], position, unsettledPosition) exec <> 'aapl us' , '2013-05-13' I receive this error: Cannot use SAVE But I can't find any way to determine if I am in a distributed transaction - Anyone any ideas of how I can find out if I am in a distributed I've tried running it with "remote proc trans" set both to a 0 and a 1.

Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Mine was caused by calling sp_add_job from a trigger. Question for SQL Server MVPs 7. You cannot post replies to polls.

How do I work around this?

Back to Top