useful TechRepublic Blog
1. get a list of all system objects from sys.objects
name,object_id,parent_object_id,type
2. determine individual dependencies from sys.sql_dependencies
object_id, referenced_major_id
3. use a topological sort to untangle the list of dependencies to a simple dependency tree.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
comment: