Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: SQL DB help needed!!!

    Dear All,

    I have a client requirement. We are integrating two applications. So the problem is that, whenever some updates (meaning to say "create" , "delete" , "update") happens in the SQL DB Tables, i needed to track that data and send it to a different system.

    What I have thought abt is that if SQL could generate a file with all the values deleted/updated/created in the DB, then I could take those values and do the needful. Please help me..

    Thanks,
    Sanjo

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You could take help of triggers in this case and by all means refer to http://msdn.microsoft.com/msdnmag/is...12/DataPoints/
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2007
    Posts
    2

    Trigger

    Hi,

    Thanks for the reply. I tried writing a Trigger

    CREATE TRIGGER Testtrigger ON [dbo].[POHEADER]
    FOR delete
    AS
    Print "cannot delete"

    Then I tried deleting a record. But nothing happened. Shouldnt the message be coming. The record infact got deleted. I may be wrong. But new to this. Is there a place where this data will be written??

    Please help,

    Warm Regards
    Sanjo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •