How to get modified time of a table

Muthu

Hello All,

I would like to get last modified timestamp for a table. Is there any way to
get that information using any commands?

Thanks in Advance,
Muthu.

Jul 11 '06 #1

Subscribe Reply

1991

Erland Sommarskog

Muthu (mu*********@gmail.com) writes:

I would like to get last modified timestamp for a table. Is there any
way to get that information using any commands?

No, there is no built-in support for this. You could have to add
a modified_date column to the table, and then use a trigger to ensure
that it's updated accordingly.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jul 11 '06 #2

--CELKO--

>I would like to get last modified timestamp for a table. Is there any way to get that information using any commands? <<

Before you send your boss to jail, you might want to look at SOX rules
for audits. Then look at third party tools for such things.

Jul 12 '06 #3

Similar topics

Database last modified

by: Shawn McKenzie | last post by:

Can someone help me with a query to get the date/time that a database was last modified? I looked at the SHOW command but there was no mention of this. TIA, Shawn

MySQL Database

table last modified date/time?

by: Rob Wahmann | last post by:

I'm curious if there is a quick way to query the date/time a table was last modified? I appreciate any tips or suggestions provided! TIA - Rob

Microsoft SQL Server

How to know which rows are modified in a database

by: Support | last post by:

Hi, I want to know if I have changed a few records in my database using update / insert / delete methods, how can i later know which rows have been changed or modified ? I know the...

.NET Framework

Update Access Table with filename, modified file date/time and values contained in these flat files

by: Pierre Maricq | last post by:

Hi, I am using Win2000 and Access2000. I need to build build a macro or write a VBA in Access that would screen all files contained in a directory on my C drive (files are structrured DAT...

Microsoft Access / VBA

102

if-modified-since question (protocol problem?)

by: hug | last post by:

www.webmaster, was suggested that this ng could be a better place.] I've updated my test server to handle if-modified-since. I've noticed that the (old copies I run of) IE and Netscape seem...

HTML / CSS

Capturing 'Last modified' information on Switchboard

by: asma410 | last post by:

Is it possible to display the file created & file modified information on a switchboard? I have designed the database so that when the user clicks on an icon on the switchboard, a form (linked to a...

Microsoft Access / VBA

HOW to check for last modified time of a table Structure in SQL Server

by: sandepmohan | last post by:

Hi I just want ot know when a table structure was modified last time in SQL SERVER? Please help ASAP Regs Sandeep

Microsoft SQL Server

UserName of the use who last modified a file in Windows

by: mazen.s.m | last post by:

I have been trying to find a way to get the Domain and UserName of the user that last modified a file. I know how to get the owner of the file via WMI or Win32, but I can't find a way to get the...

C# / C Sharp

Report - List modified fields only!

by: BobJr | last post by:

Two tables "tblEmployee" and "tblEmployeeHistory". Each table has identical fields. Each field on the form "frmEmployee" detects a change (BeforeUpdate) and checks a corresponding box (hidden...

Microsoft Access / VBA

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp