firstly:
Table A: if this table A is used inside a View or SP , i can find out that SP,View are dependent on Table A.
What about a Job uses Table A( select/Insert/delete inside a Job?), ?
we CANNOT find out ,
So it is always a best Practice to USE SP( convert existing t SQL inside a job and use in SP) in a job.
same like when applications using T SQL we cannot find out the dependencies, we need to TRACE via profiler and find out.
Find how:
we can query to find out where tableA is being used inside all databases
I Personally LIKE Redagte search
Table A: if this table A is used inside a View or SP , i can find out that SP,View are dependent on Table A.
What about a Job uses Table A( select/Insert/delete inside a Job?), ?
we CANNOT find out ,
So it is always a best Practice to USE SP( convert existing t SQL inside a job and use in SP) in a job.
same like when applications using T SQL we cannot find out the dependencies, we need to TRACE via profiler and find out.
Find how:
we can query to find out where tableA is being used inside all databases
I Personally LIKE Redagte search
No comments:
Post a Comment