Thank you !!

we have ETL process, will verify.

is there any way to find what jobs modifying these objects .
because these objects are modifying frequently.

thank you !!

its returned data. and we are trying to find how those objects modified .

default trace is enabled.

verified restore history that it is blank as it is production server.

and i have verified In SSMS, right click on Server Name, choose Reports / Standard Reports /...

Thank you.
It went fine after restarted the sqlinstance.

Yes i agree. I don't want you  debug my big SP. It is not at all fair.
I am requesting help to add the logic for 'f_current_complete_week-1' to below code...

if i execute the select statement by a automate job  then the result should be pipe-delimited text with header row.
for example the job executes a select statement   [select name,address from...