|
In one transaction I am creating a table which references another table. In a second transaction, I run a SELECT-query against the referenced table but it is blocked by the first transaction. Why is that?
Transaction A:
BEGIN TRAN CREATE TABLE Child (...
Started by Mathias on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
( MSDNyou can test this out in management studio:
1) open a new window A, run this:
CREATE TABLE Parent (id int NOT NULL primary key);....
The FK
Could it be that the first transaction is still open thus keeping a lock on the table.
|
|
Hi, After inserting into masterTable it returns an ID, with that id i want to enter more than one record into transaction table.
now i am using two seperate procedures, the problem is after inserting the record into master, and while inserting into transaction...
Answer Snippets (Read the full thread at stackoverflow):
Any and all data modifications following....
Do it inside a transaction:
BEGIN TRANSACTION EXECUTE prc_insert_master @value EXECUTE prc_insert database data modifications commands into a "all or nothing" set of work, use a transaction.
|
|
Can the SQL "truncate table" command be used within a transaction? I am creating an app and my table has a ton of records. I want to delete all the records, but if the app fails I was to rollback my transaction. Deleting each record takes a very long ...
Started by Fred Clown on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
AFAIK, if there is....
In Oracle, TRUNCATE TABLE is a DDL statement that cannot be used in a transaction (or, more accurately, cannot be rolled back).
It does write page deallocation to the log, as you mentioned .
From a transaction.
|
Ask your Facebook Friends
|
Hello All,
I'm new to SQL. I have a large number of stored procedures in my production database. I planned to write an audit table that would be used by these stored procedures to keep track of changes ( these stored procedures would write to this audit...
Started by Prabhu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
What....
Now inthe catch block for the transaction performYou can't, once a session starts a transaction all activity on that session is contained inside the transaction.
That it is a table variable and not a temp table.
|
|
When processing a batch of records, if any of them fail business rule validations the entire set of inserted data is rolled back for data integrity. During this process I need to log such errors to a table in the database - which shouldnt be rolled back...
Started by RM on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use a separate transaction and either log.
Yet? Go to the SSIS menu and select Logging.
|
|
This SQL (called from c#) occasionally results in a deadlock. The server is not under much load so the approach used is to lock as much as possible.
-- Lock to prevent race-conditions when multiple instances of an application calls this SQL: BEGIN TRANSACTION...
Started by Thomsen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Using Table Locks can a single record in the same table you are locking completely, so locking the entire table increases.
You could also avoid the table lock and use isolation level serializable.
Needs.
|
|
I have a procedure like this:
create procedure Checkout @Foo nvarchar(20), @cost float as begin transaction declare @Bar nvarchar(20); select @Bar = Bar from oFoo where Foo = @Foo; update Foo set gold = gold - @cost where name = @Foo; update Bar set gold...
Started by Omu on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
(Based on SQL Server....
This option is the SQL Server default.
Even if somebody comes transaction, resulting in nonrepeatable reads or phantom data.
But this will lock the whole table for exclusive access by that one transaction.
|
|
Hello, I want to know if open a transaction inside another is safe and encouraged?
I have a method:
def foo(): session.begin try: stuffs except Exception, e: session.rollback() raise e session.commit()
and a method that calls the first one, inside a transaction...
Answer Snippets (Read the full thread at stackoverflow):
The database knows nothing of the nesting, you can't do anything to use transaction control inside functions....
Because the transaction is virtual - i.e.
The rollback however is issued immediately.
The outermost transaction commits.
|
|
We are having problem with the server migration. We have one application that are having so much transactions It working fine on the one database server. But when transfer same database to another server. We are facing the following error.
Server: Msg...
Started by jalpesh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Are you receiving type differnce, or a data length differnce... .
So this message is a consequence, rather than a cause .
After that the transaction must fail.
This message means one of the other participants in the transaction voted to rollback.
|
|
Here are the relevant technologies that I'm working with:
Devart's dot Connect for Oracle (to facilitate Linq-to-Sql for Oracle). Strongly Typed ADO.NET Datasets. An Oracle database. Here's the challenge:
My legacy code submits database updates with ADO...
Started by Jim G. on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
When we control transactions through the connection instead of through the ORM, we use transaction.
Make sure both technologies are using the same connection instance .
To control the transaction yourself.
|
