May 23, 2010 at 11:24 am
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
"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.?
May 23, 2010 at 12:00 pm
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
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
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