Post reply

How was this table populated??

  • March 15, 2006 at 8:42 am

    #96685

    Dear all

    I am looking at someone else's d/b, and I am trying to find out how a certain table got populated.

    Suspecting an SP, I have manually gone through some of them to see if the table name is contained anywhere in the SP.  It is not however.

    So I then tried searching in the 'text' field of syscomments, alas to no avail.

    There are no obviously dependencies on this table either, so I am totally at a loss.

    Could anyone possibly help with some ideas?

    thanks

    Phil

  • March 15, 2006 at 8:53 am

    #626805

    Possibly DTS, store proc in another database?

  • March 15, 2006 at 10:54 am

    #626859

    could be from sql embeded in an application ( stupid i know but it does happen)

  • March 16, 2006 at 2:25 am

    #626955

    No - it has 200 million rows and is a fact tables

  • March 16, 2006 at 2:38 am

    #626957

    I hate to suggest it but ... trace?

  • March 16, 2006 at 2:41 am

    #626958

    no can do - am auditing static data on a test server!

  • March 16, 2006 at 3:18 am

    #626966

    If it is a fact table then it's most likely,  as Allen originally suggested, to be populated via a DTS package.

    Also if the db has been copied onto the test server it could be that the DTS package has not been transferred as well.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • March 16, 2006 at 4:42 am

    #626978

    ok, thanks - I'll dig around the DTS packages first on test then on prod to check if this is the case

    thanks for your help!

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

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