Post reply

Store procedures create and drop by it self

  • July 26, 2008 at 10:18 am

    #123375

    Hi,

    Recently one of my data base in SQL server droped and created many store procedures using the user dbo but I didn't do any thing in order to this action happened. I need to justify why this happened. Any body know something about this.

    Thank's for you help.

    LS

  • July 26, 2008 at 10:20 am

    #848794

    If you add DDL triggers you can record events like this and hopefully capture what happened.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • July 26, 2008 at 10:24 am

    #848796

    Somebody would have dropped them. SQL doesn't drop objects by itself.

    If it happened recently, you can check in the default trace to see if there's any info (default trace is in the same dir as the error log). If you want to keep track of this kind of thing in the future, set up a serverside trace or implement DDL triggers.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 26, 2008 at 10:47 am

    #848798

    check your default SQL Trace and check to see for any such activity...

    Maninder
    www.dbanation.com

  • July 26, 2008 at 10:48 am

    #848799

    Hi ,

    Do you know how I can check that.

    Sorry I'm new in database sql adminitrating.

    Thank's

    LS

  • July 26, 2008 at 11:06 am

    #848802

    The TRACE files are under the SQL Server LOG Folder by default.

    Maninder
    www.dbanation.com

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

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