locked
Stored procedure Dropped RRS feed

  • Question

  • How to find the user\login who dropped the stored procedure??
    Friday, July 22, 2016 7:40 AM

Answers

  • Hello,

    If this happened most recently then you can get the information from the defaul trace; the easiest way is in SSMS right mouse click on the database => Reports => Standard Reports => Schema Changes History


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by saravana raj Friday, July 22, 2016 9:01 AM
    Friday, July 22, 2016 8:59 AM

All replies

  • Greetings Saravan,

    unless you have logging in place (audit, triggers) i believe you cannot find out easily.
    There should be a limited number of users that can do a alteration to the model, can't you deduce it by the list?

    If you use a step-up server, you might look for the login-events to see how was active around the time the system started to give errors.

    Sebastian

    Friday, July 22, 2016 7:49 AM
  • Hello,

    If this happened most recently then you can get the information from the defaul trace; the easiest way is in SSMS right mouse click on the database => Reports => Standard Reports => Schema Changes History


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by saravana raj Friday, July 22, 2016 9:01 AM
    Friday, July 22, 2016 8:59 AM
  • do you have some mechanism for logins and other actions running there?

    For next time you can implement something like described in this link

    prevent

    Friday, July 22, 2016 11:09 AM