DependencyWalker DependencyWalker DependencyWalker Class

Definition

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.

public ref class DependencyWalker
public class DependencyWalker
Public Class DependencyWalker
Inheritance
DependencyWalkerDependencyWalkerDependencyWalker
Derived

Examples

Scripting

Remarks

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.

Constructors

DependencyWalker() DependencyWalker() DependencyWalker()

Initializes a new instance of the DependencyWalker class.

DependencyWalker(Server) DependencyWalker(Server) DependencyWalker(Server)

Initializes a new instance of the DependencyWalker class on the specified instance of SQL Server.

Properties

DependencyTree DependencyTree DependencyTree

Gets or sets a server dependency tree.

FilterCallbackFunction FilterCallbackFunction FilterCallbackFunction

Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method.

KnownObjectsList KnownObjectsList KnownObjectsList

Gets or sets a list of all known objects in a server.

Server Server Server

Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with.

Total Total Total

Gets or sets the number of objects that have been processed by the DependencyWalker object.

TotalCount TotalCount TotalCount

Gets or sets the count of objects discovered by a dependency walker.

Methods

DiscoverDependencies(UrnCollection, DependencyType) DiscoverDependencies(UrnCollection, DependencyType) DiscoverDependencies(UrnCollection, DependencyType)

Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified UrnCollection of SQL Server objects on the instance of SQL Server.

DiscoverDependencies(SqlSmoObject[], Boolean) DiscoverDependencies(SqlSmoObject[], Boolean) DiscoverDependencies(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.

DiscoverDependencies(UrnCollection, Boolean) DiscoverDependencies(UrnCollection, Boolean) DiscoverDependencies(UrnCollection, Boolean)

Creates a hierarchical object tree that represents the parent or child dependent relationships for a specified UrnCollection of SQL Server objects on the instance of SQL Server.

DiscoverDependencies(Urn[], Boolean) DiscoverDependencies(Urn[], Boolean) DiscoverDependencies(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.

DiscoverDependencies(Urn[], DependencyType) DiscoverDependencies(Urn[], DependencyType) DiscoverDependencies(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.

DiscoverDependencies(SqlSmoObject[], DependencyType) DiscoverDependencies(SqlSmoObject[], DependencyType) DiscoverDependencies(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.

GetServerObject() GetServerObject() GetServerObject()

Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running.

WalkDependencies(DependencyTree) WalkDependencies(DependencyTree) WalkDependencies(DependencyTree)

Creates a linear list of objects and their dependencies from a specified DependencyTree object.

Events

DiscoveryProgress DiscoveryProgress DiscoveryProgress

Raises an event at intervals and reports progress on the DiscoveryProgress method.

Applies to