All stored procedures overwritten?

Posted on 2006-05-10
Last Modified: 2008-02-26
Hi Experts!

Something odd happened to my db!

As far as I can scripts or dts's were one has been on the server...nothing...yet...I came in this morning and ALL my sproc's seem to have been overwritten or re-created!
They all had today's date...and changes made recently were lost!

I have no clue as to how or why this happened!

ANY ideas?

Question by:samtran0331
    LVL 142

    Accepted Solution

    either you looked on the wrong database, or someone run a script with the old version of the procedures on the database.
    you can try to use some tools like Lumingent Logexplorer to check through the transaction log file what/when it has happened, but you will NOT find back the values unless you have a backup from "yesterday"
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    Check your log files using the tools like Apex log , Lumigent log explorer .You can go thru the log and  check any alternation happened
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    Someone may  accidently ran the database script ,
    you can download the trial versions of these products from their websites .. Just google with the product name
    LVL 27

    Assisted Solution

    Someone in a hurry ran the wrong script. The database would not automatically run scripts to change procedures. You may be able to find who did it, but first you should restore a recent backup and run those scripts over the "changed" database. You also probably have missing tables or indexes.
    LVL 37

    Author Comment

    thanks everyone...I assumed "someone did something"....just wanted to make sure no one knew of any instance where SQL Server would freak out and do something like this on its own...
    LVL 27

    Expert Comment

    No, thankfully SQL Server does not decide to freak out. We had a problem with a table being dropped even though only one procedure referenced it. We went through the code and could not find the drop database. We finally found it on a different proc, where the developer had been in a hurry and left a drop table at the bottom.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now