Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DependencyWalker Class

The DependencyWalker object is a tool to perform scripting operations that involve dependencies such as identifying dependent relationships. The tool and converts this output to a list.

System.Object
  Microsoft.SqlServer.Management.Smo.DependencyWalker
    Microsoft.SqlServer.Management.Smo.Scripter

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public class DependencyWalker

The DependencyWalker type exposes the following members.

  NameDescription
Public methodDependencyWalker()Initializes a new instance of the DependencyWalker class.
Public methodDependencyWalker(Server)Initializes a new instance of the DependencyWalker class on the specified instance of SQL Server.
Top
  NameDescription
Protected propertyDependencyTreeGets or sets a server dependency tree.
Public propertyFilterCallbackFunctionGets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method.
Protected propertyKnownObjectsListGets or sets a list of all known objects in a server.
Public propertyServerGets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with.
Protected propertyTotalGets or sets the number of objects that have been processed by the DependencyWalker object.
Protected propertyTotalCountGets or sets the count of objects discovered by a dependency walker.
Top
  NameDescription
Public methodDiscoverDependencies(SqlSmoObject[], DependencyType)Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server.
Public methodDiscoverDependencies(SqlSmoObject[], Boolean)Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified object array of SQL Server objects on the instance of SQL Server.
Public methodDiscoverDependencies(Urn[], DependencyType)Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server.
Public methodDiscoverDependencies(Urn[], Boolean)Creates a hierarchical object tree that represents the parent- or child-dependent relationships for a specified Urn array of SQL Server objects on the instance of SQL Server.
Public methodDiscoverDependencies(UrnCollection, DependencyType)Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server.
Public methodDiscoverDependencies(UrnCollection, Boolean)Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified Urn collection of SQL Server objects on the instance of SQL Server.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Protected methodGetServerObjectReturns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running.
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Public methodWalkDependenciesCreates a linear list of objects and their dependencies from a specified DependencyTree object.
Top
  NameDescription
Public eventDiscoveryProgressRaises an event at intervals and reports progress on the DiscoveryProgress method.
Top

The DependencyWalker object does not represent any physical SQL Server object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.