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

From: jobi (jobi_at_reply2.group)
Date: 09/22/03 

Date: Mon, 22 Sep 2003 08:15:15 +0200

Thanks for your responce.

After re-reading my own post I 've noticed I've chosen words very poor.

I want to know when a cretain sqlserver-user-id (no windows-account) is
being used.

It's not my intention to have profiler running 24/7.

Can this be done ?

Jobi

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:u9U$eLrfDHA.132@tk2msftngp13.phx.gbl...
> > 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
>
>
>