Re: Trace sysadmin login's .

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 06/16/03 

Date: Mon, 16 Jun 2003 08:25:08 +0200

Use the Profiler, Audit Login event, create a filter on the role name. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"TLV" <tlv@prontomail.com> wrote in message
news:00c701c33376$583a2930$a401280a@phx.gbl...
> Hi ,
>
> Is there is a why to set trace filter only for sysadmin
> memeber's ?
>
> Thanks ,
>
> TLV
>

Relevant Pages

  • Re: SQL renamed expression name not recognised in WHERE
    ... OP's original query and my nested table expression ... directive as a filter on a derived value only. ... The corrected version (which run equally well under SQL Server and Oracle ...
    (comp.sys.ibm.as400.misc)
  • Re: 2005 Log Reader
    ... I am thinking 'filter' too, ... Looking for a SQL Server replication book? ... execute 'sp_replcmds' on 'PASASERV\PASLIVE'.'. ... construct replicated command from LSN.'. ...
    (microsoft.public.sqlserver.replication)
  • Re: Linked and Virtual Cubes in SSAS 2005
    ... You should not use DSO to develop new applications instead AMO is available ... Collapse AllExpand All Language Filter: AllLanguage Filter: ... This feature will be removed in the next version of Microsoft SQL Server. ... As per the SQL Server 2005 Books Online, Linked Cubes and Virtual Cubes ...
    (microsoft.public.sqlserver.olap)
  • Re: Views Show Up in SQL Server Tables List
    ... The code I gave was to filter using a TSQL statement. ... I am using the release version of the SQL Server 2005 'SQL Server ... > Microsoft Analysis Services Client Tools 2005.090.1399.00 ... >> lists of objects. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Statement Class Helper request
    ... SQL Server will do this as well for regular queries issued ... > connection (there is also the notion of "preparing" a query for use multiple ... One advantage of using Java for the connection pool - this doesn't seem ... > I agree with you that there are ways you might want to filter the query. ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast