With Profiler you can catch (almost) every line of code executed on the server. Takes a bit (OK, quite a bit, depending on what you're watching) of overhead, and disk space, again depending on what you're watching.
P
-----Original Message-----
From: PRICE MARIE
[mailto:mssqldba-ezmlmshield-x33347659.[Email address protected]
Sent: Wednesday, June 29, 2005 11:41 AM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
How can I tell what they are doing? Is there a place in the db like
with oracle. I know about sql profiler, but somehow does not do much
for me.
Marie M.Ginette Price p
Database Administrator
Pride IT Support
Waterloo Regional Police Service
200 Maple Grove Rd.
Cambridge, ON N3H 5M1
(519) 650-8500 ext 8739 office
(519) 841-2297 cell
marie.[Email address protected]
http://www.wrps.on.ca
" Alone we can do so little; together we can do so much.....Helen Keller
"
-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x95672129.[Email address protected]
Sent: June 29, 2005 11:28 AM
To: LazyDBA Discussion
Subject: RE: SQL Login Info...
You can see who's currently connected (Management, Current Activity,
Process Info), or sp_who2. Shows login time as well as last command
time. You can turn on Auditing, that info will go into the error log.
(Server, Properties, Security). This will not give you DB access info,
tho.
P
-----Original Message-----
From: Gelston John [mailto:mssqldba-ezmlmshield-x40712267.[Email address
protected]
Sent: Wednesday, June 29, 2005 11:12 AM
To: LazyDBA Discussion
Subject: SQL Login Info...
Hi,
Is there a way to view the active logins and database access on a SQL
Server, and specifically their access history - ie: last login, etc
Is this info stored in a table somewhere?
Thanks, John
The information contained in this e-mail may be confidential and is
intended solely for the use of the named addressee. Access, copying or
re-use of the e-mail or any information contained therein by any other
person is not authorized. If you are not the intended recipient please
notify us immediately by returning the e-mail to the originator.(16b)
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
**************************************************************************************************
The contents of this email and any attachments are confidential.
They are intended for the named recipient(s) only.
If you have received this email in error please notify the system manager or the
sender immediately and do not disclose the contents to anyone or make copies.
** scanned this email for viruses, vandals and malicious content. **
*** PRIDE Police Services ***
**************************************************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page