No announcements
Found 1044816 threads
-
0 VotesUnable to lock tables for deployment.
It is unfortunate that this drops all tables data, especially as there are a number of static data or reference tables.Answered | 3 Replies | 688 Views | Created by Rohan Bacon - Friday, October 2, 2015 3:07 PM | Last reply by Fei Xue - Wednesday, October 7, 2015 7:49 AM
-
0 Votes
Table locks
So with so many locks I think its causing table locks.Answered | 6 Replies | 1157 Views | Created by oleolehoohoo - Thursday, October 29, 2015 3:32 PM | Last reply by Shanky_621 - Friday, October 30, 2015 7:57 AM -
1 Votes
Locking the table
SQL Server will lock the table for the update.Answered | 20 Replies | 4569 Views | Created by kchokkal - Wednesday, March 3, 2010 8:08 PM | Last reply by Adam_Turner - Friday, March 5, 2010 4:49 AM -
0 Votes
Locks on tables.
request_reference_count 1 request_session_id 124 ...Answered | 7 Replies | 1519 Views | Created by venkatesh1985 - Wednesday, November 26, 2014 10:23 PM | Last reply by Shanky_621 - Thursday, November 27, 2014 7:37 PM -
1 Votes
Lock in one single table
It seems that there are table level locks, such as the exclusive lock, which is incompatible with IX lock, are held on these tables until the ...Answered | 5 Replies | 2725 Views | Created by Iniciante em SQL - Thursday, November 24, 2011 1:08 PM | Last reply by Stephanie Lv - Tuesday, November 29, 2011 7:29 AM -
0 Votes
Transactions and table locking
Are you saying that it's possible that a table lock does not have to happen?Answered | 10 Replies | 1526 Views | Created by GiantSoftware - Thursday, September 3, 2015 2:55 PM | Last reply by GiantSoftware - Monday, September 14, 2015 4:32 PM -
0 Votes
SQL Server TABLE Locking
You may be intending to DENY INSERT, UPDATE, and DELETE permissions to the table.Answered | 4 Replies | 6648 Views | Created by MrAvgProgrammer - Wednesday, August 15, 2012 3:54 PM | Last reply by Rick Byham, Microsoft - Wednesday, August 15, 2012 4:17 PM -
0 Votes
Table locks
If the plan used by the application was less efficient (e.g. full scan) and touched rows locked by other sessions, the query might block.Answered | 3 Replies | 1267 Views | Created by Curendra - Thursday, August 8, 2019 11:16 AM | Last reply by Dmitri Korotkevitch - Thursday, August 8, 2019 9:09 PM -
2 Votes
Record Locking in a vfp table
RLOCK() should always return .T. when called on exclusively open table (and the table just created is open exclusively).Answered | 3 Replies | 1865 Views | Created by dduser1984 - Thursday, January 28, 2016 10:30 AM | Last reply by Olaf Doschke - Wednesday, February 17, 2016 9:40 AM -
0 Votes
Table Locking with TABLOCK
As long as there is no escalation to table lock, that is.Answered | 7 Replies | 3380 Views | Created by TheBrenda - Tuesday, October 20, 2015 7:39 PM | Last reply by TheBrenda - Friday, October 30, 2015 1:07 PM -
2 Votes
UPDATE lock on table
The other rows in the table not be locked.Answered | 15 Replies | 5206 Views | Created by simonxy - Friday, September 27, 2013 1:33 PM | Last reply by simonxy - Thursday, October 3, 2013 8:44 AM -
0 Votes
Sync Framework Locking the table
which table is it "locking"?Answered | 7 Replies | 8994 Views | Created by Varde - Monday, September 27, 2010 3:38 PM | Last reply by JuneT - Tuesday, September 28, 2010 11:01 PM -
1 Votes
Read Lock on table
COMMIT TRANSACTION UPDLOCK is not an exclusive lock, but other processes can still read that row.Answered | 3 Replies | 2815 Views | Created by Khalid Kagzi - Friday, April 6, 2018 9:48 AM | Last reply by Erland Sommarskog - Friday, April 6, 2018 9:10 PM -
1 Votes
Lock 'Childreen' Table
You can not lock SELECTs If you use CREATE TABLE t1 (c int) BEGIN TRAN SELECT top 0 ...Answered | 5 Replies | 7587 Views | Created by isane - Thursday, October 26, 2006 1:23 PM | Last reply by Uri Dimant - Monday, March 24, 2014 7:41 AM -
2 Votes
Prevent locking at table level
If the queries starts with row locks and then escalates to table locks, then one can configure lock escalation with ALTER TABLE - but ...Answered | 6 Replies | 1042 Views | Created by gib898 - Wednesday, March 7, 2018 11:42 PM | Last reply by TiborK - Friday, March 9, 2018 10:38 AM -
0 Votes
Clear locks on Tables
Hello, All locks are removed automatically (of course) as soon as the transaction is finished; eighter commited or rollback.Answered | 1 Replies | 2897 Views | Created by VijayKSQL - Wednesday, October 31, 2012 3:07 PM | Last reply by Olaf Helper - Wednesday, October 31, 2012 5:25 PM -
0 Votes
Bulk Insert Without Locking Table
When you specify table locking for a bulk import operation, a bulk update (BU) lock is taken on the table for the duration of the bulk-import operation.Answered | 2 Replies | 13210 Views | Created by Jhakir - Thursday, March 7, 2013 10:22 PM | Last reply by Kalman Toth - Friday, March 15, 2013 3:23 PM -
2 Votes
sysobjects table locking up
More precisely I tried this SELECT * INTO nisse FROM [NATSUMORI\SQLXI].Northwind.dbo.Orders And prior to that, I had set up a ...Answered | 3 Replies | 2674 Views | Created by Cornelia Gibbs - Tuesday, March 25, 2014 7:48 PM | Last reply by JRStern - Tuesday, March 25, 2014 10:56 PM -
0 Votes
Excel files locking tables
This basically prevents reads from ever producing locks on the data.Answered | 1 Replies | 2715 Views | Created by layziee - Thursday, January 26, 2012 10:22 PM | Last reply by SQLWork - Friday, January 27, 2012 9:53 PM -
0 Votes
What is best practice in terms of locking / not locking tables?
Read http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/ http://www.sqlteam.com/article/introduction-to-locking- ...Answered | 5 Replies | 1464 Views | Created by falcon00 - Thursday, January 17, 2013 9:43 PM | Last reply by ganeshkuppuswamy - Friday, January 18, 2013 6:54 AM - Items 1 to 20 of 1044816 Next ›
No announcements
