?
Solved

DBCC OPENTRAN

Posted on 2010-08-19
2
Medium Priority
?
539 Views
Last Modified: 2012-05-10
The result is
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Is it referring to only BEGIN TRAN transactions?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 5

Accepted Solution

by:
jijeesh earned 2000 total points
ID: 33477986
DBCC OPENTRAN returns the following result set when there are no open transactions:

"No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
"

see below sample from SQL Server BooksOnline

CREATE TABLE T1(Col1 int, Col2 char(3));
GO
BEGIN TRAN
INSERT INTO T1 VALUES (101, 'abc');
GO
DBCC OPENTRAN;
ROLLBACK TRAN;
GO
DROP TABLE T1;
GO

Open in new window

0
 
LVL 6

Author Comment

by:anushahanna
ID: 33478486
Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question