Post reply

Database changes

  • July 7, 2003 at 3:57 am

    #59335

    I need to trace changes made to my production database by developers.

    I can't deny them dbowner permission, so I need a script or a little tool to investigate db and fing what they have modified.

    Thanks in advance

  • July 7, 2003 at 4:01 am

    #464246

    Hi maxwell,

    quote:

    I need to trace changes made to my production database by developers.

    I can't deny them dbowner permission, so I need a script or a little tool to investigate db and fing what they have modified.

    I haven't done this before, but take a look at BOL for 'c2 audit mode option'

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 7, 2003 at 4:13 am

    #464248

    You can definitely get it by running a trace. Why can't you kick them out of db_owners? Developers have no business making changes on a production box, definitely shouldn't be doing it without you being involved.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • July 8, 2003 at 5:52 am

    #464454

    Hello Maxwell,

    If you are concerned about schema changes, I recommend you download Schema Alert from Lumigent. It is a free download. It has helped me monitor changes to the DB schema.

    http://www.lumigent.com/

    Mike

  • July 9, 2003 at 1:38 pm

    #464730

    You could also try SQLDiff by Lockwood tech (www.lockwoodtech.com). I have been playing with this and looks like a pretty nice tool.

  • July 10, 2003 at 5:20 am

    #464796

    Buy SQL compare

  • July 10, 2003 at 9:57 am

    #464918

    write your own

    John Zacharkan


    John Zacharkan

  • July 10, 2003 at 10:16 am

    #464921

    just having fun, why reinvent a perfectly good working wheel. I would look into getting product demo from these companies and then make a sound decision based on budget and functionality.

    quote:

    write your own

    John Zacharkan

    John Zacharkan


    John Zacharkan

  • July 10, 2003 at 11:31 am

    #464944

    Andy & Others,

    I need to monitor it in the midnight. Is there a way to set the profiler to start and stop at a specific time. I know I can specify the end time. Can the start time can also be specified? thanks

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

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