Post reply

Need to know from which application the data has been inserted to a particular table

  • December 22, 2009 at 12:43 am

    #137773

    Hi,

    Is there any way to find out from which frontEnd application the data is inserted into a particular table (in SQL Server 2005)?

    Currently the application is not generating any logs(I mean there is no log being created by the application into the database)

    the database is idle now. No transactions are happening. I need to know from which application the data has been inserted previously.

    Thanks,

    KB

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

  • December 22, 2009 at 12:56 am

    #1095264

    It would be easier to start tracing the data inserted from now on.

    The only thing that comes to my mind is the default trace, that is reset every time the service restarts, and, in this case, won't be very useful. I don't think you have any chance to retrieve this kind of information consistently.

    I suggest you to try to find a particular pattern in data that can be tied to a single application.

    Good Luck!

    Gianluca

    -- Gianluca Sartori

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply