Re: Database access
From: Simon (me_at_me.me)
Date: 07/19/04
- Next message: sqlgirl: "Re: Exchange 2003 and "xp_sendmail: failed with mail error 0x80070005" error"
- Previous message: D: "Re: xp_cmdshell not creating txt file"
- In reply to: Kalen Delaney: "Re: Database access"
- Next in thread: Simon: "Re: Database access"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 16:03:51 -0400
Hi Kalen.... "Simon" is my pen name... you may remember me
from our discussions via email a couple weeks back revolving
around the aging out of statistics that Microsoft changed on you
after your book went to press.... You may remember me!
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:O$7w0rcbEHA.644@tk2msftngp13.phx.gbl...
> 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 :)
> > >
> > >
> >
> >
>
>
- Next message: sqlgirl: "Re: Exchange 2003 and "xp_sendmail: failed with mail error 0x80070005" error"
- Previous message: D: "Re: xp_cmdshell not creating txt file"
- In reply to: Kalen Delaney: "Re: Database access"
- Next in thread: Simon: "Re: Database access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
