Post reply

detect change in a database

  • May 23, 2010 at 11:24 am

    #232691

    Hi

    I need to find out what tables in a database changed after an operation how wouls I do this? query master/msdb before and after ????

  • May 23, 2010 at 11:44 am

    #1171311

    "what tables changed" do you mean?

    1. Table definition (such as add / delete a column, or alter column type / size, or add / remove / alter a contraint or index)?

    2. Data in a table by means of a Add, Update, or Delete of data.?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 23, 2010 at 12:00 pm

    #1171313

    Please clarify for us as Ron has requested.

    Knowing whether you mean table definition or data, will have an impact on the answer.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 23, 2010 at 12:08 pm

    #1171315

    Thanks for the prompt response guys,

    What i want to do is in this test database I have a "Black Box" application that when run will add/modify database records if I can run the app "it registers an employees request absence" then I can see what it does to register said employees absence

  • May 23, 2010 at 12:54 pm

    #1171319

    Use profiler while running that application.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 1 through 4 (of 4 total)

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