SQL Server Performance

Track modifed date and time of a stored procedure

Discussion in 'General Developer Questions' started by WingSzeto, Jan 9, 2006.

  1. WingSzeto Member

    Is there an automatic method to track when a stored procedure is changed and/or what login is used?

  2. Luis Martin Moderator

    With profiler you can add login name column to find out what user is using sp.

    Luis Martin

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

Share This Page