Very Computer

Cheers

Chris aka *Boo

Check out the documentation on DBCC OPENTRAN in the SQL Server Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> I am having a problem with uncommitted SQL transactions, as a
> precaution I am executing SQL as transactions, then checking the
> number of rows affected matches my expectations. It also might have
> something to do with the fact that the data I am dealing with is worth
> more than my life (hehehe). The past few days I have had uncommitted
> SQL transactions from the previous evening's work.
> Now I know the easy answer to my question is donot run Transactions
> orcheck that night that you have committed them all. But is there a
> Stored Procedure or an SQL statement that would allow a DBA to look at
> all the uncommited SQL Transactions.

> Cheers

> Chris aka *Boo

The following query will display all users who have uncommitted transactions
that haven't issued a batch to the server in the last 60 seconds.

select spid, hostname, loginame, open_tran As [Tran Count]
from master..sysprocesses
where
    open_tran > 0
    and datediff (ss, last_batch, getdate ()) > 60

Quote:> I am having a problem with uncommitted SQL transactions, as a
> precaution I am executing SQL as transactions, then checking the
> number of rows affected matches my expectations. It also might have
> something to do with the fact that the data I am dealing with is worth
> more than my life (hehehe). The past few days I have had uncommitted
> SQL transactions from the previous evening's work.
> Now I know the easy answer to my question is donot run Transactions
> orcheck that night that you have committed them all. But is there a
> Stored Procedure or an SQL statement that would allow a DBA to look at
> all the uncommited SQL Transactions.

> Cheers

> Chris aka *Boo

Have now created a nice little file which will tell me if there is any
uncomitted SQL.

Chris