Developing

Introduction

Sometimes we need to see if there is an open transaction.

Nesse post mostrarei como ver quais as transações estão abertas no SQL Server.

SQL

Select *
from sysprocesses
where open_tran > 0

This query will provide list of all the open transaction details.

Make sure you run this query in master database.

Also View

SQL Server – Variáveis Table

SQL Server – nvarchar(max) Limit

SQL Server  – TimeStamp

SQL Server – Remover Acentos

SQL Server – DATEDIFF

_____

Não se esqueça de deixar seu comentário, critica, elogio, dúvida e etc. Ele é muito importante para a melhoria do blog.
Do not forget to leave your comments, criticism, praise, questions, etc.. It is very important for improving the blog.

Advertisements

Comments on: "SQL Server – Open Transactions Details" (2)

  1. […] SQL Server – Open Transactions Details […]

  2. […] SQL Server – Open Transactions Details […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: