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.

Inheritance Hierarchy

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)

Syntax

'Declaration
Public Class DependencyWalker
'Usage
Dim instance As DependencyWalker

public class DependencyWalker

public ref class DependencyWalker

type DependencyWalker =  class end

public class DependencyWalker

The DependencyWalker type exposes the following members.

Constructors

	Name	Description
	DependencyWalker()	Initializes a new instance of the DependencyWalker class.
	DependencyWalker(Server)	Initializes a new instance of the DependencyWalker class on the specified instance of SQL Server.

Top

Properties

	Name	Description
	DependencyTree	Gets or sets a server dependency tree.
	FilterCallbackFunction	Gets or sets the scripting options that allow URNs to be filtered out while running the DiscoverDependencies method.
	KnownObjectsList	Gets or sets a list of all known objects in a server.
	Server	Gets or sets the instance of Microsoft SQL Server that the DependencyWalker tool object is associated with.
	Total	Gets or sets the number of objects that have been processed by the DependencyWalker object.
	TotalCount	Gets or sets the count of objects discovered by a dependency walker.

Top

Methods

	Name	Description
	DiscoverDependencies(array<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.
	DiscoverDependencies(array<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(array<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(array<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(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.
	DiscoverDependencies(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.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetServerObject	Returns the Server object that represents the instance of SQL Server on which the dependency discovery operation is running.
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)
	WalkDependencies	Creates a linear list of objects and their dependencies from a specified DependencyTree object.

Top

Events

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

Top

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.

Examples

Scripting

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace