Re: Database access

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Simon (me_at_me.me)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 15:22:57 -0400

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: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Database options
    ... > be able synchronize the Pocket PC database with its PC counterpart. ... > app to be a stand-alone app not needing an MS SQL server. ... we supply an object database engine that allows you to store C# ... objects directly: db4o. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database options
    ... > be able synchronize the Pocket PC database with its PC counterpart. ... > app to be a stand-alone app not needing an MS SQL server. ... we supply an object database engine that allows you to store C# ... objects directly: db4o. ...
    (microsoft.public.pocketpc.developer)
  • Re: Storing Negative vs. Positive Values in DB
    ... I would store the ... > Thanks, Tom, but are you suggesting that maybe Access does have problems? ... > We give our users the option of using either Access or SQL Server. ... >> Perhaps a stupid database design question, ...
    (microsoft.public.vb.database.ado)
  • Re: Storing and Retreiving RichTextBox Image Objects in SQL Server Database
    ... can do is to store the binaries in an Image column. ... record stored in an MS Access Database - in a Memo Field ... the image in the RichTextBox. ... and how I can emulate the same behavior in our SQL Server ...
    (microsoft.public.sqlserver.programming)