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: SQL Server Express versus Access (In the World Series of Love)
    ... If your need involve a form, then triggers are not an appropriate tool: ... after a change in the database. ... OF triggers to achieve the same, say, over view, so, advantage to Jet. ... MS SQL Server may have a horse shoe maker right out of the box, ...
    (microsoft.public.access.modulesdaovba)
  • 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)