Re: How can I audit the use of one sql-id

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 09/19/03


Date: Fri, 19 Sep 2003 15:33:59 +0200


> How can I audit the use of a single sql-id.
>
> This Id is only to be used in specific circumstances and should always be
> reported.

Id of what? If you are talking about object id, use Profiler. If you wand to
audit a single row, use a trigger.

-- 
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


Relevant Pages

  • Re: output header and trailer?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org ... >>data" phase of a multi-phase DTS pump, but was never able to get it working. ...
    (microsoft.public.sqlserver.dts)
  • Re: violation of primary key constraint
    ... >>> Darren Green (SQL Server MVP) ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Applications ,Roles and users
    ... Wayne Snyder, MCDBA, SQL Server MVP ... >> (Please respond only to the newsgroups.) ... >> community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Column Encryption sql server 2000
    ... Ariana, ... Dejan Sarka, SQL Server MVP ... Please reply only to the newsgroups. ... PASS - the definitive, global community ...
    (microsoft.public.sqlserver.security)
  • Re: transforming the export
    ... processed the COUNTRY attribute. ... Allan Mitchell (Microsoft SQL Server MVP) ... I support PASS - the definitive, global community ... for SQL Server professionals - http://www.sqlpass.org ...
    (microsoft.public.sqlserver.dts)