Professional Web Applications Themes

Does sql allow us to find out when a table has been changed? - Microsoft SQL / MS SQL Server

Without going to the table itself, can we determine if and when a table has been changed after its creation date? I know the sysobjects will list the creation date (crdate) but is there a way to see when the table has been last updated. (Update,insert, delete) *** Sent via Developersdex [url]http://www.developersdex.com[/url] *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Does sql allow us to find out when a table has been changed?

    Without going to the table itself, can we determine if and when a table
    has been changed after its creation date? I know the sysobjects will
    list the creation date (crdate) but is there a way to see when the table
    has been last updated. (Update,insert, delete)


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Jesse Fitterer Guest

  2. #2

    Default Re: Does sql allow us to find out when a table has been changed?

    No, not natively. You can add a trigger that will update a datetime column
    but it has to be done manually.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Jesse Fitterer" <anonymousdevdex.com> wrote in message
    news:%23D$%234v2PDHA.2676TK2MSFTNGP10.phx.gbl...
    > Without going to the table itself, can we determine if and when a table
    > has been changed after its creation date? I know the sysobjects will
    > list the creation date (crdate) but is there a way to see when the table
    > has been last updated. (Update,insert, delete)
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Andrew J. Kelly Guest

  3. #3

    Default Re: Does sql allow us to find out when a table has been changed?

    Here is a snippet which will work:

    CREATE TRIGGER UpdateTracker
    ON tblYourTable
    FOR INSERT, UPDATE, DELETE
    AS
    BEGIN
    --Update table timestamp
    UPDATE logTableLastUpdated
    SET lastmodified = CURRENT_TIMESTAMP
    WHERE name = 'tblYourTable'
    END


    "Jesse Fitterer" <anonymousdevdex.com> wrote in message
    news:#D$#4v2PDHA.2676TK2MSFTNGP10.phx.gbl...
    > Without going to the table itself, can we determine if and when a table
    > has been changed after its creation date? I know the sysobjects will
    > list the creation date (crdate) but is there a way to see when the table
    > has been last updated. (Update,insert, delete)
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Ty Guest

Similar Threads

  1. How can I find a datagrid's source Table Name?
    By joel in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: September 3rd, 03:58 PM
  2. Replies: 2
    Last Post: August 12th, 07:55 AM
  3. SELECT to find items NOT common in a table
    By Ivan Demkovitch in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 8th, 08:10 PM
  4. How to find duplicate records in the table?
    By mac in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 7th, 07:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139