Tracking DataBase Changes(DML)

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

Other SQL Server Topics (2005)

Tracking DataBase Changes(DML)

Author

Topic

duggiralasarath
Starting Member

2 Posts

Posted - 2009-03-18 : 08:05:26

Hii friends,
I need to dispaly all the changes in a database.
Required details are-----> 1)Record data(Before changing and after changing) 2)modified date
same for all DML Statements(insert,delete,modify)

here the point is whatever DataBase is selected,have to show all modifications in the tables of the DatBase in a time period

how to handle this..please help me
Thanks in Advance
Sarath D

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-03-19 : 05:48:06

Use DBCC Commands

Eg:-

DBCC CHECKDB ('<database_name>')

Regards

Senthil.C
----------------------------------------------------------------------------
Server: Msg 3902, Level 16, State 1, Line 1
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

duggiralasarath
Starting Member

2 Posts

Posted - 2009-03-19 : 07:36:02

Thank u verymuch Senthi

But iam verymuch new to this DBCC things.
can u just tell me wt command suits for my requirement.

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-19 : 07:52:22

quote:
Originally posted by senthil_nagore

Use DBCC Commands

Eg:-

DBCC CHECKDB ('<database_name>')

Regards

Senthil.C
----------------------------------------------------------------------------
Server: Msg 3902, Level 16, State 1, Line 1
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

DBCC CHECKDB is used for something entirely different. Its for running integrity checks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources