List of Database Users

In certain applications, it would be useful to be able to display to an
'ordinary' user, a list of other accessors of a particular database. Any
ideas how this can be done?
--
John AustinJohn
Lookup sysusers system table in the BOL
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
> In certain applications, it would be useful to be able to display to an
> 'ordinary' user, a list of other accessors of a particular database. Any
> ideas how this can be done?
> --
> John Austin|||To add on to Uri's response, other methods include executing sp_helpuser or
using DMO.
Hope this helps.
Dan Guzman
SQL Server MVP
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
> In certain applications, it would be useful to be able to display to an
> 'ordinary' user, a list of other accessors of a particular database. Any
> ideas how this can be done?
> --
> John Austin|||sysusers and sp_helpuser seem to show all the users set up for the database
-
I really want to know about those with an open connection such as can be see
n
in Enterprise Manager in 'Management', 'Current Activity', 'Process Info'
Thanks
--
John Austin
"Dan Guzman" wrote:

> To add on to Uri's response, other methods include executing sp_helpuser o
r
> using DMO.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "John Austin" <John.Austin@.nospam.nospam> wrote in message
> news:1B2F5FAB-E1E6-46DE-9A63-2F00234DD581@.microsoft.com...
>
>|||sp_who, for instance
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Austin" <John.Austin@.nospam.nospam> wrote in message
news:D8EE51EF-3662-4ED7-A311-F6A26EE6F08B@.microsoft.com...
> sysusers and sp_helpuser seem to show all the users set up for the databas
e -
> I really want to know about those with an open connection such as can be s
een
> in Enterprise Manager in 'Management', 'Current Activity', 'Process Info'
> Thanks
> --
> John Austin
>
> "Dan Guzman" wrote:
>

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....
One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....
|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager
|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager