Objects

SQL-DMO

SQL-DMO

Objects

A SQL-DMO object exposes the attributes of a Microsoft® SQL Server™ 2000 component.

Properties
Parent Property UserData Property
TypeOf Property  
Remarks

All SQL-DMO objects expose properties. For a specific instance of an object, the properties identify a specific SQL Server component. For example, the SystemDatatype object with a Name value varchar has properties that define the SQL Server data type varchar.

Some objects expose methods that act on a component as directed by the application. For example, the Script method of a StoredProcedure object creates a Transact-SQL script that can re-create the referenced SQL Server stored procedure.

Some objects support events. Events communicate from the SQL-DMO object to the application. For example, the PercentComplete event of a Backup object provides notification that the backup operation specified has reached an application-defined point.