Thursday, February 4, 2016

we cannot find Table Dependencies if the Job is using Table name visa T SQL

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

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...