Post reply

MS SQL 2000 - How do I track a user who deleted SQL DB objects?

  • November 17, 2007 at 11:18 am

    #70511

    Hello All,

    Newbie here, Just wondering is there a way to track down what logged in user (mixed mode) who deleted a stored procedure? We have several developers with rights that will allow this but no one wants to admit to the mistake. Is there a log I am overlooking that records actions to database objects? Will enabling C2 auditing capture these actions?

    Any assistance would be appreciated.

    Thankyou

  • November 18, 2007 at 1:44 pm

    #752109

    Hi,

    Yes it does.

    Check the following links

    http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/

    http://www.databasejournal.com/features/mssql/article.php/3399241

    Regards,

    Ahmed

  • November 18, 2007 at 2:20 pm

    #752110

    We use Idera's Compliance Manager for this

    Funny story. Lead Developer came storming down because 3 of his stored procedures were missing. We had recently refreshed the testing area from production, and they were in production, so they should be in the test area. I considered re-restoring the production backup to make sure they were there at the time of the restore. But first, I check the Compliance Manager logs in the test area, and found HE HAD DELETED them !!! D'OH !!

    "Oh, I guess I must have done it by mistake somehow ..."

  • November 18, 2007 at 2:27 pm

    #752111

    Hi homebrew01,

    Is there any overhead on SQL Server when using the Idera tool.

    Thanks.

  • November 18, 2007 at 2:53 pm

    #752113

    I suppose there must be some, but they claim it's very minimal. It seems worth the benefit, and we haven't noticed any problems. It has lots of setting so you can customize what is monitored, and if you want alerts or not.

  • November 18, 2007 at 2:56 pm

    #752115

    Hi,

    Thanks I will download the trial and try it.

    Thanks again.

  • November 19, 2007 at 7:31 am

    #752271

    Thankyou for your information and assistance.

  • November 19, 2007 at 11:24 am

    #752418

    We use Compliance Managere and it uses a server side trace which is very light weight. It is very rare that it will hit 2% of CPU in Task Manager.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Viewing 8 posts - 1 through 7 (of 7 total)

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