Browse by Tags

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

Published 15 May 8 3:14 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: An ongoing MS DTC transaction is...

Filed under: sql server, kba, transaction, 2005, msdtc, issues

SQL Server: Quick way to find Active & idle connections on a SQL instance

Published 2 May 8 4:32 AM | SSQA.net

Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system...

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"

Published 11 January 8 9:35 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, transaction, maintenance, errorr, 3314, 9001, 9002

SQL Server MSDTC service - do you need it or not?

Published 11 October 7 7:2 AM | SSQA.net

MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent...

Filed under: sql server, services, kba, transaction, clustering, msdtc, servers, end, begin

FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005

Published 25 August 7 4:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, isolation, kba, transaction, cursor, level

FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

Published 23 August 7 6:25 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005

Published 22 August 7 4:5 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, transaction, log shipping

TSQL to identify the transaction with the most locks

Published 31 July 7 9:25 AM | SSQA.net

SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Read More...

Filed under: sql server, performance, transaction, tsql, locks

FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction"

Published 9 July 7 3:55 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you commit a distributed...

Filed under: sql server, server, kba, transaction, linked

FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005

Published 22 May 7 12:54 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated...

Filed under: sql server, dbcc, kba, transaction, index, dbreindex