Results 1 to 2 of 2

Thread: How can I detect changes automatically in the SQL Server Database ?

  1. #1
    Junior Member
    Join Date
    Mar 2007
    Answers
    1

    How can I detect changes automatically in the SQL Server Database ?

    Hi everyone,
    This is my first post here and I dont know whether I am posting my question on the right forum section.
    I been asked recently in the interview that
    How can I detect changes automatically in the SQL Server Database when anything is updated, deleted or inserted?
    I dont actually know the answer for this question, if anyone can help me in this that will be really great.
    Thanks in Advance


  2. #2
    Junior Member
    Join Date
    Apr 2007
    Answers
    9

    Re: How can I detect changes automatically in the SQL Server Database ?

    Hi,

    I´m not perfekt in this topic and I don´t know any auomatically help, which is checking database regular. But to know, if new lines are inserted is easy: count *, save result and repeat after a while :-)
    Also with deleting.

    But anyway, if you save timestamp, if anything changes in database, you can make I statement with all statement from last week (e.g.)

    I hope, this will help you.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact