Need to track the changes of database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need to track the changes of database

Author

Topic

urzsuresh
Starting Member

30 Posts

Posted - 2011-01-24 : 03:21:54

Hi
In sql2005 or Sql2008, is there any possibility to find since last month, what r the manipution have done in sql (i.e insert ,update,delete, creation in database makuse of any log file). That i need to track this manually. Can you please guide .

Suri

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-01-24 : 10:29:12

For Data, you will need to track it yourself. Or you can try this:

[url]http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/[/url]

For objects (for instance stored procedures), you can use this query to determine what objects have changed but it won't say what the changes were:

SELECT
  *
FROM
  sys.objects M
WHERE
  Modify_Date > '2011-1-01'
ORDER BY
  1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources