Re: finding out when last time column was updated

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 10:34:24 -0400

SQL Server keeps no record of when columns are altered.

The only idea I have is that you could find a backup from two years ago and
compare the two databases...

"Steven Scaife" <sp@nospam.com> wrote in message
news:Oyp1XADkEHA.2664@TK2MSFTNGP11.phx.gbl...
> I have found the sp_columns, and sp_tables procedures for creating a data
> dictionary, is there any way to find out when the last time a particular
> column was updated. I need to find all the columns that haven't been
> updated for two years, not sure why but i do.
>
> any ideas
>
> thanks in advance
>
>

Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Scheduling a Daily Backup of a SQL Database
    ... history for the job step usually has some more details. ... as if they are only set to SIMPLE you just need to backup the database. ... have found out how to backup ypur databases, you should be sure that you are ... SQL Server 2008 Standard for its database. ...
    (microsoft.public.sqlserver.server)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)