Search Results

So when a transaction is started on a connection, all the T-SQL statements (S/I/U/D) executed on that connection are a part of the transaction until the transaction ends. … under the covers to make the transaction work properly? …

If I have a sequence container and it is marked as "transaction required" and I have tasks in that sequence container that are marked as "transaction supported", if all the tasks in the container are finished … successfully does SSIS commit the transaction when it is done with the sequence container or does the transaction live past the end of the sequence container? …

Sys.dm_tran_locks  will list all current locks which are granted or pending. You can join it on session_id with  sys.dm_exec_sessions  will list all current sessions which includes client host name an …

are there any restrictions around selecting data from the subscriber whilst transactions are being applied to it? There are no restrictions for selecting data on subscriber side. Will perform …

The most reliable blocking tool that I have found is beta_lockinfo written by Erland Sommarskog. Excellent documentation and very detailed SP that gets a ton of info to help troubleshoot blocking si …

The command that you posted just run the transaction in the SP with TRANSACTION ISOLATION LEVEL SERIALIZABLE. …

One transaction will be able to see uncommitted changes made by other transaction. … Implicit & Explicit Transaction Insert took 2 secs. For an explicit transaction, the log buffers will be flushed only when they are full. …

From BOL UPDLOCK Specifies that update locks are to be taken and held until the transaction completes. UPDLOCK takes update locks for read operations only at the row-level or page-level. … The update locks acquired will be held for the remainder of the transaction. Update locks are compatible with shared locks but are not compatible with other update locks. …

how they could find out who deleted some data in their SQL Server database Although this is answered, wanted to add that SQL Server has a default trace enabled and it can be used to find out who …

From my test, I can see that the transaction IDs match (see below) Using sp_WhoIsActive with @get_transaction_info = 1, I get below transaction detail test_HV: 15 (1 kB),tempdb: 0 (0 kB),AdventureWorks … You are using SET TRANSACTION ISOLATION LEVEL REPEATABLE READ. …

. */ what would happen if I happen to restore those transaction log ? …

If you want to understand more about Transaction Log Management then refer to Stairway to Transaction Log Management As s side note, SybaseASE even in newer version Sybase 15.7 has this option (As a matter …