Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm just getting into sql-server, so forgive me if this is a basic question. I'm building an application using .NET 4.0 and VS 2010 and ms-server2008.

For my application I need to detect the server response, suppose: in db-server I need to detect which table insert/update/delete records, and which is the affected record is?

Is there any mechanism or technique to detect the server response.

If have any questions please ask.

share|improve this question
    

1 Answer 1

up vote 1 down vote accepted

Your options are

  • to use stored procedures for data access and write log of changes,
  • or to use triggers on specified tables to write log of changes

and after it you have periodically poll the log tables to reflect to the tables changes

See related answers:

http://stackoverflow.com/questions/8998545/notifications-from-sqlserver-to-java/8998579#8998579

http://stackoverflow.com/questions/8895595/sql-server-track-table-inserts/8895683#8895683

share|improve this answer
    
Oleg Dok thanks for reply.can u plz show me some sample or example,i want to know this process name is? –  shamim Jan 29 '12 at 6:44
    
Updated answer. –  Oleg Dok Jan 29 '12 at 6:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.