Browse by Tags

How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?

Published 28 August 8 3:1 AM | SSQA.net

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...

Filed under: sql server, oracle, transactions, ssma, dtc, data-migration, autonomous, mode

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?

Published 6 May 8 3:2 AM | SSQA.net

This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure...

Filed under: sql server, transaction log, spid, transactions, processes, sysprocesses, kill, rollback, kpid, sp_who2

FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"

Published 4 February 8 3:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure that references a linked server...

Filed under: sql server, kba, x64, 2005, transactions, context, linked server

FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005

Published 26 September 7 3:34 AM | SSQA.net

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

Filed under: sql server, kba, database mirroring, principal, transactions, mirror, failover

DTS package, how will optimizer treats the transactions?

Published 2 August 7 7:52 AM | SSQA.net

With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked...

Filed under: performance, dts, table, statistics, transactions, join

Vote for RESUMABLE TRANSACTIONS feature to include in SQL Server 2008

Published 19 July 7 3:46 PM | SSQA.net

In oracle IF a session start with RESUMABLET RASACTION , If any DATA FILE got full for any reason the transactions running in that Session they will be waiting until you add more datafiles. However,In current version of SQL if it ran out of space in data...

Filed under: sql server, microsoft, release, 2008, conn, transactions