Re: How to get modified time of a table

Muthu (muthuviji.k@xxxxxxxxx) 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, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: 3 Simple Security SQL Statements
    ... Builds a list of text commands. ... You could also use a DDL trigger to grant rights to WebUserRole ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Too Many SET Options
    ... By default its creating lot of 'SET' commands. ... the script to work with an indexed view or an indexed computed column. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: where to get more info on...
    ... SQL Server Books Online is the definitive documentation for these stored ... Apart from that you can look at the source code of these stored ... example when using regular OS commands at a command prompt you can usually ...
    (microsoft.public.sqlserver.server)
  • Re: SQLAgent 2005 SP1 failed to run .bat file.
    ... Create a test file a.txt in E:\firefly. ... Create E:\firefly\test.bat file with the following commands: ... Find the job under SQL Server Agent, ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: 3 Simple Security SQL Statements
    ... If you run the SELECT in a query window, it generates the list of commands ... There is procedure called sp_executesql that will take a string and execute ... Kalen Delaney, SQL Server MVP ... Builds a list of text commands. ...
    (microsoft.public.sqlserver.security)