Post reply

Self-changing stored procedures

  • January 29, 2004 at 7:44 am

    #161102

    This one has me stumped.  Over the last year I have noticed stored procedures that seem to revert to older versions all on their own.

    This morning I caught one thanks to our new source control system.  I performed an "alter procedure" yesterday at 3:30pm.  Today at 9:00am it had switched back to an older version.

    Does anyone have any ideas on where I should start looking?

  • January 29, 2004 at 1:56 pm

    #492257

    Your colleagues

     

    Actually that's the most likely reason, but I supposed there could be some issue. I'd run Profiler on the object in question for a few days and see what you get.

Viewing 2 posts - 1 through 2 (of 2 total)

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