| Author |
how to log users opening enterprise mgr for a server to a table
|
|
| Dennis S. Pierce 2002-06-22, 8:31 pm |
| any help would be appreciated.
thanks.
| |
| Ron Talmage 2002-06-22, 8:31 pm |
| Dennis,
You can audit such activity using the audit facilities in SQL Server 2000's
SQL Trace facility. See the Security Audit events in Profiler.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
Dennis S. Pierce <dsp@e-a.net> wrote in message
news:OGpRQAKECHA.2440@tkmsftngp05...
> any help would be appreciated.
>
> thanks.
>
>
| |
| Dennis S. Pierce 2002-06-22, 8:31 pm |
| i don't want to run profiler, the overhead would kill me. i need this to run
all the time to check who is accessing my sql servers via enterprise
manager. is there a system variable or something similar that can be
captured when this activity occurs?
thanks.
"Ron Talmage" <rtalmage@prospice.com> wrote in message
news:Os$xVHKECHA.1064@tkmsftngp04...
> Dennis,
>
> You can audit such activity using the audit facilities in SQL Server
2000's
> SQL Trace facility. See the Security Audit events in Profiler.
>
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
>
> Dennis S. Pierce <dsp@e-a.net> wrote in message
> news:OGpRQAKECHA.2440@tkmsftngp05...
> > any help would be appreciated.
> >
> > thanks.
> >
> >
>
>
| |
| Andrew J. Kelly 2002-06-22, 8:31 pm |
| You can try the utility at http://www.sqlpower.com It monitors the network
traffic and thus has no impact on SQL Server but I don't know how to
accomplish specifically what your after. You can probably find a command
that EM always issues and monitor for that.
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
"Dennis S. Pierce" <dsp@e-a.net> wrote in message
news:#U7qDOKECHA.2232@tkmsftngp04...
> i don't want to run profiler, the overhead would kill me. i need this to
run
> all the time to check who is accessing my sql servers via enterprise
> manager. is there a system variable or something similar that can be
> captured when this activity occurs?
>
> thanks.
>
>
>
>
> "Ron Talmage" <rtalmage@prospice.com> wrote in message
> news:Os$xVHKECHA.1064@tkmsftngp04...
> > Dennis,
> >
> > You can audit such activity using the audit facilities in SQL Server
> 2000's
> > SQL Trace facility. See the Security Audit events in Profiler.
> >
> > Hope this helps,
> > Ron
> > --
> > Ron Talmage
> > SQL Server MVP
> >
> > Dennis S. Pierce <dsp@e-a.net> wrote in message
> > news:OGpRQAKECHA.2440@tkmsftngp05...
> > > any help would be appreciated.
> > >
> > > thanks.
> > >
> > >
> >
> >
>
>
| |
| William Chen [MS] 2002-06-22, 8:31 pm |
| You can view the users who login to SQL Server through Enterprise Manager
using the following query:
select * from master..sysprocesses where program_name='MS SQLEM'
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks,
William Chen
| |
| Dennis S. Pierce 2002-06-22, 8:31 pm |
| thanks william. this is exactly what i needed. have a great day.
"William Chen [MS]" <willchen@onlinemicrosoft.com> wrote in message
news:3QvIvYRECHA.1772@cpmsftngxa07...
> You can view the users who login to SQL Server through Enterprise Manager
> using the following query:
>
> select * from master..sysprocesses where program_name='MS SQLEM'
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Thanks,
>
> William Chen
>
|
|
|
|