August 20, 2013 at 1:05 am
Comments posted to this topic are about the item Fastest way to find DB object dependencies
August 20, 2013 at 9:03 am
The solution was tidy, but I'm not sure calling the referenced object a "child" of the dbobject makes much sense. Also, I found another limitation (and one I cannot offer a fix for): Sometimes not all the dependencies for views come through. I have a view with multiple CTEs. In one environment 5 of 6 references were found. In another, a different set of 5 of the 6 references were found. I cannot fathom why that would happen.
August 28, 2013 at 2:41 am
Sorry for the late reply. Thanks for your feedback.
Calling the referenced object a "child" of the dbobject was something of requirement at my end. I assumed people using the code may change it as per their needs, so I kept it as it is.
I couldn't recreate the scenario you pointed out. It would be helpful if you could share more details about it so the issue can be tackled.
August 29, 2013 at 11:25 am
I can't think of a good way to produce an example of the issue I found. Just imagine that your view has more than one CTE and each CTE has different references. In my database, I found that only some of the references were logged in the sys.sql_dependencies table. Oddly enough, in other environments the same thing happened, but a different subset of referenced objects were logged. Perhaps it had something to do with changes to the referenced objects. Perhaps the view just needed to be re-compiled in order that the dependencies be updated. The problem is (if I have to re-compile everything) that wouldn't be feasible, I think.
September 12, 2013 at 2:06 pm
You can try a free addin for SQL Server Management Studio - SQL Refactor Studio (http://sqlrefactorstudio.com/)
Key Features:
- Advanced Search dependences of object (databases, files on disk, query editor)
- Advanced Search dependencies free text (in databases, files on disk, query editor)
- Refactoring "Rename"
- Refactoring "Add CRUD Methods"
- Refactoring "Move columns"
- Refactoring "Add lookup table"
- Formatting SQL code
- And many other useful features!
______________________________
Sincerely,
SQL Refactor Studio Team
http://sqlrefactorstudio.com/
January 2, 2014 at 9:01 am
will this work on SQL 2K5 instance ?
April 7, 2015 at 7:21 am
Thanks. I changed the column names to be a bit more friendly to me.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy