No announcements
Found 2918792 threads
-
0 VotesThe procedure 'sp_replicationdboption' cannot be executed within a transaction
'sp_replicationdboption' cannot be executed within a transaction. What is a solution? I ...Proposed | 2 Replies | 1199 Views | Created by Kupiecu - Monday, November 19, 2018 3:49 PM | Last reply by Emily Fei - Tuesday, November 20, 2018 6:09 AM
-
0 Votes
Replication distribution database issue
, Procedure sp_replicationdboption, Line 114 The procedure 'sp_replicationdboption' cannot be executed ...Answered | 8 Replies | 929 Views | Created by Change123 - Thursday, October 15, 2015 11:41 AM | Last reply by Lydia Zhang - Friday, October 16, 2015 2:26 AM -
0 Votes
the procedure 'sp_addrolemember' cannot be executed within a transaction
error every time he tries to insert or update into the table. "the procedure 'sp_addrolemember' cannot be executed within ...Answered | 1 Replies | 11193 Views | Created by msaeida - Monday, July 9, 2007 9:54 PM | Last reply by Raul Garcia - MS - Tuesday, July 10, 2007 6:15 PM -
0 Votes
The procedure 'sys.sp_procoption' cannot be executed within a transaction
migration I get the error: The procedure 'sys.sp_procoption' cannot be executed within a ...Answered | 1 Replies | 8456 Views | Created by Reuvy - Thursday, August 13, 2009 10:06 AM | Last reply by JasonHowell - Sunday, August 16, 2009 2:53 AM -
2 Votes
Persistent replication error messages
Msg 15002, Level 16, State 1, Procedure sp_replicationdboption, Line 94 The procedure 'sp_replicationdboption' cannot ...Answered | 7 Replies | 9079 Views | Created by GAINSCOM - Tuesday, April 6, 2010 11:48 AM | Last reply by GAINSCOM - Tuesday, April 6, 2010 2:49 PM -
0 Votes
Error- Operation cannot perform within a transaction
HI All, I am trying to run a simple truncate statement for a table using Talend Open studio, but I am getting error saying -"Operation cannot ...Answered | 1 Replies | 2489 Views | Created by Ajinkya Gonnade - Thursday, December 7, 2017 12:08 PM | Last reply by Murshed Zaman_MSFT - Thursday, December 7, 2017 4:30 PM -
0 Votes
Transaction within a procedure that is called from another procedure
-rollback-transaction-named-transaction If true and ROLLBACK called from within a nested procedure, in fact rolls ...Answered | 7 Replies | 1544 Views | Created by shiftbit - Thursday, August 15, 2013 7:13 PM | Last reply by shiftbit - Thursday, August 15, 2013 10:45 PM -
0 Votes
Combining DDL Within A Transaction With DDL That Cannot Be Within A Transaction
complicating factor is that some of the objects are full-text indexes. These cannot be completed as part of a transaction. I'm ...Answered | 7 Replies | 1768 Views | Created by Ken Powers - Wednesday, November 13, 2013 2:52 PM | Last reply by Ken Powers - Wednesday, November 13, 2013 9:06 PM -
0 Votes
The transaction cannot be aborted...
Hi, I get the following error during sync with a windows mobile 6.1 device. "The transaction cannot be ...Answered | 1 Replies | 5880 Views | Created by Aristeidis Bampakos - Monday, January 2, 2012 2:20 PM | Last reply by Aristeidis Bampakos - Thursday, January 5, 2012 8:12 AM -
0 Votes
sp_executesql vs transaction statement within Stored Procedure
Experts, Any difference between sp_executesql vs Transaction/Commit statement or try/catch block within Stored Procedure? What is ...Answered | 2 Replies | 1213 Views | Created by gk1393 - Monday, June 2, 2014 3:47 PM | Last reply by Naomi N - Monday, June 2, 2014 6:10 PM -
0 Votes
sql2005:Cannot use SAVE TRANSACTION within a distributed transaction
Cannot use SAVE TRANSACTION within a distributed transaction.Anyone encounter transaction problem with replication ???Thanks.Answered | 9 Replies | 17600 Views | Created by TheReverend - Monday, October 10, 2005 2:38 PM | Last reply by javamick - Tuesday, January 3, 2006 9:52 PM -
0 Votes
question to transaction within a transaction
Hello i have following question to a transaction-scope: if i use a transaction-scope, call a method that have its own ...Answered | 2 Replies | 2866 Views | Created by M.Erlinger - Monday, January 25, 2010 10:59 AM | Last reply by M.Erlinger - Monday, January 25, 2010 2:42 PM -
0 Votes
the current transaction cannot be commit...
thank you. I cannot modify the transaction statements to include within the TRY...CATCH blcok, because the try..catch block is ...Answered | 14 Replies | 5615 Views | Created by anne with e - Wednesday, May 26, 2010 6:28 AM | Last reply by nithinvtm - Thursday, October 24, 2013 11:16 AM -
0 Votes
transaction including a stored procedure
If you mean the commit in your stored procedure is ignored, yes, it is. >>2.If I did not assign a transaction, then the stored ...Answered | 2 Replies | 513 Views | Created by DavidThi808 - Wednesday, October 8, 2014 12:36 AM | Last reply by DavidThi808 - Wednesday, October 8, 2014 12:28 PM -
0 Votes
How to avoid a stored procedure to be executed parallel
; Insert into table L4 } I want to avoid this stored procedure to be executed ...Answered | 6 Replies | 6490 Views | Created by VijayVZ - Thursday, June 30, 2011 9:29 AM | Last reply by --CELKO-- - Wednesday, July 6, 2011 2:48 AM -
0 Votes
The current transaction cannot be committed and cannot support operations
n error "The current transaction cannot be committed and cannot support operations that write to the log file" in my production ...Answered | 5 Replies | 15074 Views | Created by Shalem. T J - Monday, November 12, 2012 2:14 PM | Last reply by Ahsan Kabir - Thursday, November 15, 2012 3:25 PM -
4 Votes
The current transaction cannot be committed and cannot be rolled back to a savepoint
cannot catch this with TRY-CATCH. 2) The batch is aborted, and the current transaction is rolled back. If there is a CATCH handler, ...Answered | 4 Replies | 14489 Views | Created by 曾新文 - Wednesday, December 26, 2012 8:06 AM | Last reply by Erland Sommarskog - Wednesday, December 26, 2012 10:08 AM -
2 Votes
command can not be used within transaction.
You know what, I think I know where the error could be coming from. It could come from a trigger's code. If you have RI enabled, the code in VFP RI (if I recall ...Answered | 19 Replies | 3423 Views | Created by Tariq Iftikhar - Wednesday, October 26, 2011 5:54 AM | Last reply by Naomi N - Wednesday, November 9, 2011 2:09 PM -
0 Votes
Procedure within the merge
Please have a look at the documentation regarding the merge statement. A stored procedure is not a valid <table source>. ...Answered | 4 Replies | 1551 Views | Created by Thirunavukkarasu-BI - Friday, July 19, 2013 10:44 PM | Last reply by Thirunavukkarasu-BI - Tuesday, July 23, 2013 6:18 AM -
1 Votes
Cannot find stored procedure in Programmability despite being executed successfully
Stored Procedures I cannot find it. After refreshingAnswered | 2 Replies | 1281 Views | Created by Sarthak aka bhaiya - Tuesday, April 8, 2014 5:55 AM | Last reply by Visakh16 - Tuesday, April 8, 2014 6:35 AM - Items 1 to 20 of 2918792 Next ›
No announcements
