Re: Database access

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 12:59:41 -0700

Hi Simon

This is correct, but not the whole story.
Triggers cannot be created on ANY system table, not just the virtual tables. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Simon" <me@me.me> wrote in message
news:OtiIOXcbEHA.252@TK2MSFTNGP10.phx.gbl...
>
> I believe the sysprocesses table is a virtual table and triggers cannot be
> defined on them.
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> news:e0SwCIbbEHA.1248@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > SQL Server will not store this information into any tables. Only way is
to
> > run the profiler or write you own triger to monitor the
> master..sysprocesses
> > table
> > and log the audit information into a table. Later you could query the
> table
> > to get the last access date and time for the database.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Sara Beth" <Sara Beth@discussions.microsoft.com> wrote in message
> > news:1978F2D2-6D5D-45E9-8DAC-F9C548B5E0A3@microsoft.com...
> > > Is there any way to query SQL Server to see the last time a given
> database
> > was access?
> > >
> > > thanks guys :)
> >
> >
>
>

Relevant Pages

  • Re: Audit trail for web application
    ... This is more of a SQL Server question than an ASP.NET question. ... with implenting auditing at the application level or using table triggers is ... There are also 3rd party database auditing tools that should do ... > I am trying one approach with the help of triggers. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Database access
    ... > SQL Server will not store this information into any tables. ... > and log the audit information into a table. ... > to get the last access date and time for the database. ... >> Is there any way to query SQL Server to see the last time a given database ...
    (microsoft.public.sqlserver.server)
  • Re: New to SQL server
    ... it is called triggers. ... ANYTHING THAT YOU CAN DO IN JET IS BABY TALK COMPARED TO WHAT WE CAN DO ... anything that you can do in JET that I can't do in SQL Server ... self-referencing FKs and inline constraints. ...
    (microsoft.public.access.adp.sqlserver)
  • Write conflict error after adding trigger to table
    ... I have inherited an Access adp that directly connects to SQL Server. ... that database. ... stored proc in the database window instead of through the form, ... is preventing me from rolling these triggers to production where other apps ...
    (microsoft.public.access.adp.sqlserver)
  • Re: need information for "Before Select" Trigger
    ... As i've added "Enforced Constraints" ... There are no BEFORE SELECT triggers. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)