Post reply

way to find out from where or how the data loaded into table

  • December 19, 2009 at 10:53 am

    #228628

    is there a way to find out from where or how the data loaded into table

    for eg. data can be loaded into table by a store proc, by a job(SSIS) or manually entering etc

    is there any way to know from which of the above mentioned method used to load data into table????

  • December 19, 2009 at 10:55 am

    #1094470

    Hi

    You can use SQL Profiler to trace your table. Another option would be a trigger.

    Greets

    Flo

  • December 19, 2009 at 11:08 am

    #1094472

    thanx fr the reply can u explain in detail as iam a new to sql 2005

  • December 19, 2009 at 11:27 am

    #1094474

    You can find Profiler in menu -> Tools -> SQL Profiler. Have a look for events "SQL:BatchCompleted" and "RPC:BatchCompleted".

    For triggers read this article:

    CREATE TRIGGER

    Greets

    Flo

  • December 21, 2009 at 1:48 pm

    #1095086

    SQL Profiler will report on current/ongoing database activity. It almost sounded from your post that you want to know about historical data insertion. In this case you would need to have transaction log backups and a third party tool that can read these backups.

  • December 22, 2009 at 10:47 am

    #1095541

    emily-1119612 (12/21/2009)

    SQL Profiler will report on current/ongoing database activity. It almost sounded from your post that you want to know about historical data insertion. In this case you would need to have transaction log backups and a third party tool that can read these backups.

    ya exactly .. does we need to create the transaction log's manually ? or they will be in system itself

  • December 22, 2009 at 11:28 am

    #1095564

    I think you are out of luck. Anything we can provide you in the qay of guidance will help you going forward, but what has happened in the past is just that, past.

  • December 22, 2009 at 1:41 pm

    #1095662

    ya exactly .. does we need to create the transaction log's manually ? or they will be in system itself

    The transaction log backups would already need to be in existence. Check with your DBA. If you have these transaction log backups you will need a third party tool to read these logs. This is one example. http://www.apexsql.com/sql_tools_log.asp

    If the transaction log backups don't exist then I don't believe you will be able to re-create these past data events.

Viewing 8 posts - 1 through 7 (of 7 total)

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