August 25, 2009 at 6:22 am
Hello team,
I am using following version of sql server
@@version = Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1
I run following command to open one transaction
begin tran aa
go
But dbcc opentran() doesn't give me any information.
--No active open transactions.
--DBCC execution completed. If DBCC printed error messages, contact your system administrator.
But when I execute commit then the transaction is committed.
Is there any change in opening the transaction in sql server 2008?
-LK
August 25, 2009 at 6:39 am
If you’ll check the value of @@trancount, you’ll see that it is 1. Also if you’ll run a statement that modifies any data in the transaction before you run the dbcc opentran statement, you’ll see that there is an open transaction. Since you opened a transaction, but didn’t modify any data at all, the DBCC OPENTRAN statement didn’t return data about any open transaction
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 25, 2009 at 7:04 am
Thanks Adi.
-LK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply