detect change in a database

• Rob 8503

  Old Hand

  Points: 320

  More actions

  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 ????

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  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]

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  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

• Rob 8503

  Old Hand

  Points: 320

  More actions

  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

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  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