Wednesday, March 28, 2012

how do i look through the log to see updates to tables in sql sever 2005?

hi. changes were made to a dababase and we need to read the log file to see how much exactly was changed and what. how do i read the log file in sql server 2005 with out buying 3rd party software?I posted a reply in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=655927&SiteID=1|||

hi winston,

if you want a cheaper alternative to know what has changed

you can use a database snapshot solution

as a baseline for comparison.

there's no easy way of looking at the logs

you have to use a 3rd party tools such as lumigent or apex sql

joey

|||thanks lads. i ended up getting ApexSQL Log.

No comments:

Post a Comment