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
 General SQL Server Forums
 New to SQL Server Administration
 Trck changes in table in sql server

Author  Topic 

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-08-04 : 08:35:29
Hi,

We are development of mobile application and have database in sql sever. what I need to track is to track the changes(insert,update,delete) in table.

Is there any way I can track the changes in table instead of trigger on tables as trigger may effect the server responce time and that is main concern in case of mobile application? I belive The AUDIT functionality of sql server does not work except enterprise version and we are in beta so no enterprise.

I tried google but could not get effective solution.

Please help!
Pushp

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-08-04 : 09:01:36
Changed Data Capture without Using Trigger
http://connectsql.blogspot.com/2011/06/sql-server-date-change-capture-without.html

Or you can use SQL Server 2008 CDC feature
http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/


--------------------------
http://connectsql.blogspot.com/
Go to Top of Page

pushp82
Yak Posting Veteran

83 Posts

Posted - 2012-08-06 : 01:25:39
nice.. thanks

quote:
Originally posted by lionofdezert

Changed Data Capture without Using Trigger
http://connectsql.blogspot.com/2011/06/sql-server-date-change-capture-without.html

Or you can use SQL Server 2008 CDC feature
http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/


--------------------------
http://connectsql.blogspot.com/

Go to Top of Page
   

- Advertisement -