|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > sql command to get the last modified date of a table.
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 |
sql command to get the last modified date of a table.
|
|
|
| Hi,
I am connecting to a remote server through asp.I am able
to retrive the
table names of the servers particular database.Is there a
sql command that will
give the last modified date of a particular table of that
database.
For instance the table's particular field name was changed
or a fields datatype is changed or any other modification
has taken place.I want the date & time any of these
modifications took place in the table.
Please do get ack to me as soon as possible,
Toral
| |
| Eric Yang [MS] 2002-10-05, 9:09 pm |
| Dear Toral,
There is no such sql command which can return the last modified date for a
table. However, you can create a trigger to implement it. That is to say,
when the table is updated, a trigger will be fired to insert the current
date time into another table. This way, we can get what we want from the
table which stores the date time information.
Sincerely,
Eric Yang [MS]
Microsoft Online Support Engineer
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
|
|
|
|
|