Yes, im at lost. The developer and management didn't see eye to eye. I believe hi's departure was not pleasant and i doubt this developer will assist. So no handover...

Please explain what is meant by static? Also, how would i do a QA?

I found it retun this data for:

Yes, it is the database thats hold the table in question. I got this as an instruction:

"find out how the table is populated, fn_GetSummaryReport  only reads from the table.  If...

• This reply was modified 2 years, 5 months ago by  yrstruly.

Not getting any data back.

• This reply was modified 2 years, 5 months ago by  yrstruly.

Please send me ascreenshot of how you would do it, "YOU NEED TO PROVIDE THE 2 PART NAME WHICH INCLUDES THE SCHEMA"

Where do i modify the above code to get what i need?

All of it.

It does not work.

I ran Jeff's query, it returns nothing:

Could this tool, SQL Dependancy Traker help me get my asnwer?

Yes, i am trying to find out which stored procedure or table. I was just given this task and thrown in the deep end. I am still learning the context...

I dont quite know how i should modify your code to get the desired output?

• This reply was modified 2 years, 5 months ago by  yrstruly.

Yes, that can be the issue. Do you think it will work when there is  data in that table?

I am trying to find the stored procedure(s) that is linked to...

• This reply was modified 2 years, 5 months ago by  yrstruly.
• This reply was modified 2 years, 5 months ago by  yrstruly.

I have tested the cod as you adviced. I have not deleted the existing function for this test, is that correct? I am not getting any different results:

Please elaborate on...

• This reply was modified 2 years, 5 months ago by  yrstruly.