Finding SQL Scripts that populate table

Anna 40 Reputation points

I've inherited tables and am being asked what parameters are being used in populating the tables. I've found the script that creates the table, but where do I look to find the procedure(s) that are run when the tables are "automatically" updated?

Example: Table contains aggregated data. I need to know if the table includes all instances of a unique identifier with different issue dates or if it just includes data with the most recent issue date.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,582 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. PercyTang-MSFT 11,876 Reputation points Microsoft Vendor

    Hi @Anna Adams

    Although you gave an example, that is only a general description. You can refer to Erland's article to see if it solves your problem.

    If you need us to help you design the script, you need to provide more detailed information.

    Best regards,

    Percy Tang

    0 comments No comments