Re: Table modifications - additional information

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 07:32:46 -0400

It would be very easy to write a trigger for each of the tables that simply
updated a row with the current date/time for each insert/update/delete...
However if this is a highly concurrent database you may see this special
table as a bottleneck... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tina" <anonymous@discussions.microsoft.com> wrote in message
news:107fa01c43f86$75b88110$a501280a@phx.gbl...
> Greg,
>
> Thank you!
>
> -Tina
>
> >-----Original Message-----
> >Oh, now I get it.  The answer is still no.  But you
> might consider looking
> >at replication for supporting this
> >
> >-- 
> >
> >---------------------------------------------------------
> -------------------
> >---------------------------------------------------------
> -------------------
> >----
> >
> >Need SQL Server Examples check out my website at
> >http://www.geocities.com/sqlserverexamples
> >"Tina" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:1060901c43f7f$2f4c69f0$a301280a@phx.gbl...
> >> I think in my original question I wasn't being
> >> specific, I want to know when the data in table was
> >> last modified. Any new rows were added or old rows
> >> deleted or modified. Does the database store that
> >> kinda information?
> >>
> >> I need it because I have to port the data from one
> >> database to another only from the tables in which
> >> it was changed.
> >>
> >> Thank you,
> >> -Tina
> >>
> >> >-----Original Message-----
> >> >How can I find out when a particular table was last
> >> >modified?
> >> >
> >> >I will need the list of all tables in my database
> >> >modified after a certain date.
> >> >
> >> >Thank you,
> >> >-Tina
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • RE: database access from VC++
    ... But my database already exist in SQL server 2005. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vc.database)
  • Re: transfering ASPNETDB.MDF Authentiocation to SQLServer
    ... ** Since SQL Server Express's database(your current mdf data file based ... database) are just a standard SQL server 2005 data file, ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Express Edition Network Deployment Error
    ... You might also want to look into using one of the open source database ... The issue of "The file *.mdf is on a network path that is not supported ... SQL Server 2005 Express Edition Overview ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VSTeam Suite Database Setup
    ... I noticed that your concern is mainly about database project to support SQL Server 2008, which is a feature in Database Edition. ... For the Database Edition support to SQL Server 2008, you have to wait for the upcoming GDR edition, which is planning to finally release in Oct. of this year. ...
    (microsoft.public.vsnet.enterprise.tools)
  • RE: VB.Net app send information via HTTP to SQL server
    ... since database server(such as SQL Server is ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.languages.vb)