No announcements
Found 2370340 threads
-
1 Votesbegin tran/commit tran
The documentation for COMMIT TRANSACTION states: "Because transaction_name is ignored by the Database Engine, issuing a COMMIT TRANSACTION ...Answered | 2 Replies | 5540 Views | Created by satfaltu - Friday, July 16, 2010 6:56 AM | Last reply by satfaltu - Friday, July 16, 2010 11:01 AM
-
0 Votes
begin trans and commit trans in vb.net
please try this model Dim SqlTran As SqlTransaction = Nothing Dim SqlCmd As New SqlCommand SqlCmd.Connection = Gc_Con 'Connection object ...Answered | 3 Replies | 7228 Views | Created by Muhammad Kashan Khan - Saturday, November 17, 2012 4:57 AM | Last reply by Ahsan Kabir - Saturday, November 17, 2012 7:04 PM -
0 Votes
begin tran does the row level lock or table level lock
Lock escalation, as mentioned my Olaf is one possibility for the bloc (row level locks escalated to table level log).Answered | 5 Replies | 7904 Views | Created by Sudip_inn - Sunday, January 7, 2018 10:25 AM | Last reply by TiborK - Monday, January 8, 2018 8:04 AM -
1 Votes
LOCK/Wait on Begin Tran and Commit
Some of my data and some of other persons data are getting populated.Answered | 4 Replies | 1551 Views | Created by PB29129 - Tuesday, October 8, 2013 2:05 PM | Last reply by davidbaxterbrowne - Tuesday, October 8, 2013 2:37 PM -
0 Votes
Begin Tran and commit tran create exclusive lock on data row
User-2057865890 posted Hi Sudip_inn, A transaction always gets an exclusive lock on any data it modifies, and holds that lock ...Answered | 2 Replies | 52 Views | Created by Anonymous - Monday, October 17, 2016 10:39 AM | Last reply by Anonymous - Tuesday, October 18, 2016 6:31 AM -
0 Votes
What does BEGIN TRAN and ROLLBACK do in a query window?
These lines start a transaction and rollback it, it means what if you run an update or insert or delete command, it will not be committed.Answered | 2 Replies | 6478 Views | Created by TheSQLNewb - Friday, November 12, 2010 9:09 PM | Last reply by Naomi N - Friday, November 12, 2010 9:24 PM -
6 Votes
Missing Begin Tran, not missing?
Hallo, that's quite simple - the error occures before the tran begin.Answered | 7 Replies | 3057 Views | Created by Domski74 - Thursday, September 15, 2011 12:02 PM | Last reply by Mariano Gomez - Thursday, September 15, 2011 3:11 PM -
0 Votes
Locks in SQL Server 2008
As you said, the table only has one record, this means that the records will always have a exclusive lock while updating.Answered | 5 Replies | 4941 Views | Created by Fernando Miguel - Tuesday, July 7, 2009 9:11 PM | Last reply by Fernando Miguel - Wednesday, July 8, 2009 9:14 AM -
2 Votes
Tranning Center
i just know about microsoft tranning center available in India.If YES please Email me @Dharmarajchougale@gmail.comAnswered | 2 Replies | 5387 Views | Created by dharmarajchougale - Thursday, June 7, 2012 3:01 PM | Last reply by Nate Stammer - Thursday, June 7, 2012 4:20 PM -
1 Votes
Locking the table
Use transactions(BEGIN TRAN COMMIT TRAN or ROLLBACK TRAN) if you are modifying the table and you want all the code to succeed or fail, as the examples ...Answered | 20 Replies | 4395 Views | Created by kchokkal - Wednesday, March 3, 2010 8:08 PM | Last reply by Adam_Turner - Friday, March 5, 2010 4:49 AM -
1 Votes
Delete records in a table without logging in Tran log
Be wary of lock escalation 2.Answered | 5 Replies | 4849 Views | Created by Preetha7 - Thursday, June 27, 2013 4:42 AM | Last reply by Sean Gallardy - Thursday, June 27, 2013 2:20 PM -
6 Votes
Trimming trans log (sql 2008)
Setting up it as a lesser number will force SQL server to expand the size frequently [which will create an extra overhead to SQL Server].Answered | 10 Replies | 1230 Views | Created by edm2 - Monday, March 10, 2014 3:11 PM | Last reply by Shanky_621 - Tuesday, March 11, 2014 1:58 PM -
1 Votes
Exclusive rows on transaction with UPDLOCK
The code I need to run (apart from the row exclusivity) is the following: BEGIN TRY BEGIN ...Answered | 18 Replies | 1906 Views | Created by Pakojones - Tuesday, February 14, 2017 9:59 PM | Last reply by Dan Guzman - Friday, February 17, 2017 11:44 AM -
0 Votes
Why does the Tran Log Grow During a Rollback
I have also learnt this the hard way once and the best practice is to create another table [hope you have enough free space available] and pre-populate the data before the ...Answered | 2 Replies | 4748 Views | Created by Stamey - Friday, July 2, 2010 6:52 PM | Last reply by Sankar Reddy - Friday, July 2, 2010 8:51 PM -
4 Votes
Do i need Begin / Commit transaction when using XACT_ABORT ON?
Yes, you need BEGIN and COMMIT, if you want the operation to be atomic.Answered | 6 Replies | 7413 Views | Created by Datamartin - Tuesday, March 5, 2013 12:22 PM | Last reply by Erland Sommarskog - Tuesday, March 5, 2013 12:52 PM -
0 Votes
Avoiding Concurrency using Begin Commit Rollback Return statement and UPDLOCK, HOLDLOCK
Hi, Thank you all for the time.Without using the Locking concept(SET TRANSACTION ISOLATION LEVEL) or any UPDLOCK, i tried the below ...Answered | 11 Replies | 1636 Views | Created by Prathap Gangireddy - Saturday, July 5, 2014 11:45 AM | Last reply by Prathap Gangireddy - Monday, July 7, 2014 9:41 AM -
0 Votes
dbcc opentran detect all open trans?
It is possible for a long running job to begin and commit transactions hundreds or thousands of times in a big task.Answered | 4 Replies | 12708 Views | Created by George Zhou - Thursday, July 12, 2012 3:09 PM | Last reply by SQLWork - Thursday, July 12, 2012 7:05 PM -
2 Votes
Lock for reading
0 begin print 'insert OK' COMMIT ...Answered | 7 Replies | 1578 Views | Created by Ove Kernell - Wednesday, February 6, 2013 1:20 PM | Last reply by Ove Kernell - Thursday, February 7, 2013 4:21 PM -
0 Votes
Begin Tran, Commit Tran
is it much better compared to rollback trans?Answered | 3 Replies | 11849 Views | Created by chempz - Monday, October 8, 2007 11:09 PM | Last reply by chempz - Tuesday, October 9, 2007 4:24 AM -
0 Votes
putting less pressure on the tran log in a recovery simple db
to tell sql to take commits at a certain size during inserts themselves?Answered | 1 Replies | 721 Views | Created by db042190 - Friday, March 22, 2019 12:15 PM | Last reply by Olaf Helper - Friday, March 22, 2019 1:20 PM - Items 1 to 20 of 2370340 Next ›
No announcements
