sysprocesses

From: dnlgauthier@xxxxxxxxxxx
Date: Tue, 14 Aug 2007 09:47:16 -0700

prior to SQL Server 2005, a login was able to select * from
master..sysprocesses and see all active SPIDs. Now using SQL Server
2005 the same select only returns the SPID for the active connection,
unless the user has "processadmin" role enabled. How can I view all
active connections WITHOUT having to enable the processadmin role for
the user ?

.

Follow-Ups:
- Re: sysprocesses
  - From: Russell Fields

Prev by Date: Re: Rights to execute jobs?
Next by Date: Re: sysprocesses
Previous by thread: Re: Rights to execute jobs?
Next by thread: Re: sysprocesses
Index(es):
- Date
- Thread

Relevant Pages

Dropping an active connection on an attached database
... active connection on an attached database in SQL Server Management ... I can't detach an attached database because apparently there ...
(comp.databases.ms-sqlserver)
Re: Dropping an active connection on an attached database
... active connection on an attached database in SQL Server Management ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
(comp.databases.ms-sqlserver)
Re: Dropping an active connection on an attached database
... active connection on an attached database in SQL Server Management ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Cannot create a new connection because in manual or distributed transaction
... The Microsoft OLE DB Provider for SQL Server does not allow more than one ... active connection within the scope of a transaction. ... Use a server-side or client-side cursor other than the forward-only and ... > And we cannot identifiy the scenario causing ...
(borland.public.delphi.database.ado)