March 16, 2010 at 10:57 am
Is there any way to know when and where data gets written on a specific database using sql server 2005.
thanks in advance.
March 16, 2010 at 11:02 am
Would you mind explaining further what you are looking for? Your question is a little vague.
March 16, 2010 at 11:10 am
I agree with Lynn. This question is a little vague.
You state transaction log of a database, but you ask where data gets written. Please elaborate.
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
March 16, 2010 at 12:25 pm
Ok!
I need to know where can i look for the specific date when data changes gets comitted on a table.
thank guys!
March 16, 2010 at 12:41 pm
igngua (3/16/2010)
Ok!I need to know where can i look for the specific date when data changes gets comitted on a table.
thank guys!
To find when specific data changed in a table - you should add a field to the table to track that.
Otherwise, the transaction log would hold the changes with timestamps.
You would have to purchase some software to read through the logs for that though.
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
March 17, 2010 at 7:23 am
igngua (3/16/2010)
Is there any way to know when and where data gets written on a specific database using sql server 2005.
Not without adding some manual auditing code. Quite a lot of it in fact.
SQL Server 2008 offers Change Data Capture - which is a lot easier.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply