Current activity shows lots of SPID with open transactions...yet DBCC open tran shows no a

Anyone know why this is?
SQL Server 2000 sp3a.
There are about 200 spids in the database that show an open
transaction in the current activity window.
Yet, when I run a dbcc opentran on the database, it says no active
transactions.
An open transaction is one that has not yet commited correct? So
shouldn't it show up in DBCC opentran?
Thanks for any input.
"Sanctus" <mchi55@.hotmail.com> wrote in message
news:1175796327.218453.112050@.p77g2000hsh.googlegr oups.com...
> Anyone know why this is?
> SQL Server 2000 sp3a.
> There are about 200 spids in the database that show an open
> transaction in the current activity window.
> Yet, when I run a dbcc opentran on the database, it says no active
> transactions.
> An open transaction is one that has not yet commited correct? So
> shouldn't it show up in DBCC opentran?
How are you determining the 200 Spids have open transactions?
Note that you may have 200 CONNECTIONS, but they may not be doing anything,
or they're doing very short transactions so you never get a chance to see
them with DBCC OpenTran.

> Thanks for any input.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Current activity shows lots of SPID with open transactions...yet DBCC open tran shows no a

Anyone know why this is?
SQL Server 2000 sp3a.
There are about 200 spids in the database that show an open
transaction in the current activity window.
Yet, when I run a dbcc opentran on the database, it says no active
transactions.
An open transaction is one that has not yet commited correct? So
shouldn't it show up in DBCC opentran?
Thanks for any input."Sanctus" <mchi55@.hotmail.com> wrote in message
news:1175796327.218453.112050@.p77g2000hsh.googlegroups.com...
> Anyone know why this is?
> SQL Server 2000 sp3a.
> There are about 200 spids in the database that show an open
> transaction in the current activity window.
> Yet, when I run a dbcc opentran on the database, it says no active
> transactions.
> An open transaction is one that has not yet commited correct? So
> shouldn't it show up in DBCC opentran?
How are you determining the 200 Spids have open transactions?
Note that you may have 200 CONNECTIONS, but they may not be doing anything,
or they're doing very short transactions so you never get a chance to see
them with DBCC OpenTran.
> Thanks for any input.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.
From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.

CSDVersion key for Service Pack

I was looking up the changes in SP3 and SP3a, and basically the ways to
identify the service pack is installed on the system. In one of the
references I found that the CSDVersion key under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
has changed.
I wanted to know whether the CSDVersion key changes with every service pack
release.From what I have heard, that is not a reliable measure.
"Harshal" <Harshal@.discussions.microsoft.com> wrote in message
news:AAE3B70A-AEDE-4350-B872-D44697DD759F@.microsoft.com...
> I was looking up the changes in SP3 and SP3a, and basically the ways to
> identify the service pack is installed on the system. In one of the
> references I found that the CSDVersion key under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersi
on
> has changed.
> I wanted to know whether the CSDVersion key changes with every service
> pack
> release.