Results 1 to 4 of 4

Thread: Alteration date

  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: Alteration date

    THere's a create date stored in Sysobjects, but is it true that there's no track of alteration dates?

  2. #2
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78
    I also have been unable to find one.
    In my case I'm planning to use sp_table_validation to generate a checksum to determine whether a table has been altered.

    - Andy Abel

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    About sp_table_validation - is there anything similar for other objects than tables?

    I thought about searching for a certain string in an SP's code, a string where the user that made the last change wrote his/her signature as a comment. Our developers are fairly disciplined...
    But, the 'text' attribute of syscomments was hard to understand, since selecting it using left() and substr() functions gave very different results compared to doing just a select on the attribute. I need to use a string function to truncate the 'text' attribute because it's so wide.

  4. #4
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78
    Rather than using substring() you could pattern matching if you know the form of the comment you're looking for. i.e. you could use:

    where text like '%Version%'

    or use patindex() with substr() to locate the beginning of your comment section and do a substring from that point.

    substring(text,PATINDEX('%Version%', text),255)

    - Andy Abel

Posting Permissions

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