Post reply

Last Modified Date of stored procedure

  • March 20, 2009 at 4:50 am

    #202453

    Hi Experts

    IS it possible to find the Last Modified Date of stored procedure in SQL server 2000 .

    sysobjects gives me only the created time

    Thax

    Tanx 😀

  • March 20, 2009 at 9:49 am

    #963627

    This info isn't stored anywhere in SQL 2000.

    Greg

  • March 24, 2009 at 2:15 pm

    #965597

    What about when a table was last modified that doesn't involve using a trigger?

  • March 24, 2009 at 2:39 pm

    #965615

    Are you looking for that last time data in the table was changed, or the last time the table structure was changed (added a column, for example)?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 25, 2009 at 5:53 am

    #965912

    I'm referring to when a table was inserted into or deleted from.

  • March 25, 2009 at 5:55 am

    #965915

    I'm referring to when a table was inserted into or deleted from.

  • March 25, 2009 at 6:09 am

    #965920

    Laura Schmalzbauer (3/25/2009)

    I'm referring to when a table was inserted into or deleted from.

    For that you'll have to use trace or trigger or to use stored procedure to allow data modification, and in the procedure insert the logging data into a different table (notice that administrators will be able to modify data in the table directly).

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • March 25, 2009 at 6:34 am

    #965935

    Laura Schmalzbauer (3/25/2009)

    I'm referring to when a table was inserted into or deleted from.

    For that you'll have to use trace or trigger or to use stored procedure to allow data modification, and in the procedure insert the logging data into a different table (notice that administrators will be able to modify data in the table directly).

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply