|
Home > Archive > MS SQL Server > July 2005 > When was object last updated
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
When was object last updated
|
|
|
| In SQL Server 2000, how can I tell when an object (table,view) was last
updated?
| |
| Hari Prasad 2005-07-21, 1:23 pm |
| Hi,
SQL Server 2000 will not store the object modified date and time in any
system table. Only way to identify that is by enabling Profiler or read the
transaction logs
using Log explorer from www.Lumigent.com.
For data modifications in a Table or Indexed view can attained by writing an
Update trigger.
Thanks
Hari
SQL Server MVP
"Vince" <vincent.rineer@capbluecross.com> wrote in message
news:uzG1Q4hjFHA.2152@TK2MSFTNGP14.phx.gbl...
> In SQL Server 2000, how can I tell when an object (table,view) was last
> updated?
>
>
| |
| David Gugick 2005-07-21, 8:23 pm |
| Vince wrote:
> In SQL Server 2000, how can I tell when an object (table,view) was
> last updated?
There's no way to tell this from SQL Server 7/2000. The crdate column in
sysobjects is updated when a table/object is dropped and recreated, but
is not updated when an object is ALTERed. You can probably use the
base_schem_ver to indicate if the table was changed, but no dates are
associated with the change.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
| |
| mark baekdal 2005-07-22, 3:23 am |
| Get a real database change management process in place. Using DB Ghost with
your source control you'll know how, who, where, why and when things changed.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Vince" wrote:
> In SQL Server 2000, how can I tell when an object (table,view) was last
> updated?
>
>
>
|
|
|
|
|