 |
BorlandTalk.com Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Juan Carlos Aranda Guest
|
Posted: Fri Apr 23, 2004 4:57 pm Post subject: How to use SqlDMO in Delphi ??? |
|
|
I want work with SQLDMO in delphi. I only know what sqldmo is a dll. How to
convert this dll in a file for work in delphi?.
Thanks
Juan Carlos Aranda
|
|
| Back to top |
|
 |
Euan Garden Guest
|
Posted: Sat Apr 24, 2004 12:44 am Post subject: Re: How to use SqlDMO in Delphi ??? |
|
|
SQLDMO is a COM API, do project|import type library and then use the classes
somewhat like they were delphi classes. One trick to watch out for is that
some of the autogenerated class names clash with delphi class names
(TDatabase, TApplication) so you either have to change the resolve order of
compilation in the project source file or rename the classes during import
in the teeny little edit box down the bottom.
There are samples on CC about using DMO and lots of posts, check out google.
-Euan
"Juan Carlos Aranda" <jc_aranda (AT) hotmail (DOT) com> wrote
| Quote: | I want work with SQLDMO in delphi. I only know what sqldmo is a dll. How
to
convert this dll in a file for work in delphi?.
Thanks
Juan Carlos Aranda
|
|
|
| Back to top |
|
 |
Charles Adriano Guest
|
Posted: Sat Apr 24, 2004 10:51 pm Post subject: Re: How to use SqlDMO in Delphi ??? |
|
|
here is a code and sample for SqlDMO (it's free)
the uses...
http://www.delphi32.co.yu/preuzeti_tekstovi/exploiting_sql_server_1.htm
i send to your mail the code and the sample for study....
the code for SQLDMO_TLB.Pas
unit SQLDMO_TLB;
// ************************************************************************
//
// WARNING
//
// -------
//
// The types declared in this file were generated from data read from a
//
// Type Library. If this type library is explicitly or indirectly (via
//
// another type library referring to this type library) re-imported, or the
//
// 'Refresh' command of the Type Library Editor activated while editing the
//
// Type Library, the contents of this file will be regenerated and all
//
// manual modifications will be lost.
//
// ************************************************************************
//
// PASTLWTR : $Revision: 1.11.1.75 $
// File generated on 11/12/98 3:57:29 PM from Type Library described below.
// ************************************************************************
//
// Type Lib: D:MSSQL7Binnsqldmo.ENU
// IIDLCID: {10010001-E260-11CF-AE68-00AA004A34D5}
// Helpfile: D:MSSQL7BinnSQLDMO.hlp
// HelpString: Microsoft SQLDMO Object Library
// Version: 7.0
// ************************************************************************
//
interface
uses Windows, ActiveX, Classes, Graphics, OleCtrls, StdVCL;
// *********************************************************************//
// GUIDS declared in the TypeLibrary. Following prefixes are used: //
// Type Libraries : LIBID_xxxx //
// CoClasses : CLASS_xxxx //
// DISPInterfaces : DIID_xxxx //
// Non-DISP interfaces: IID_xxxx //
// *********************************************************************//
const
LIBID_SQLDMO: TGUID = '{10010001-E260-11CF-AE68-00AA004A34D5}';
IID__IVSQLDMOStdObject: TGUID = '{10010007-E260-11CF-AE68-00AA004A34D5}';
IID__Application: TGUID = '{10020106-E260-11CF-AE68-00AA004A34D5}';
CLASS_Application_: TGUID = '{10020100-E260-11CF-AE68-00AA004A34D5}';
IID_Properties: TGUID = '{10020001-E260-11CF-AE68-00AA004A34D5}';
IID_Property_: TGUID = '{10020002-E260-11CF-AE68-00AA004A34D5}';
IID_SQLServers: TGUID = '{10020203-E260-11CF-AE68-00AA004A34D5}';
IID_ServerSink: TGUID = '{10020209-E260-11CF-AE68-00AA004A34D5}';
IID__SQLServer: TGUID = '{10020206-E260-11CF-AE68-00AA004A34D5}';
IID_Databases: TGUID = '{10020303-E260-11CF-AE68-00AA004A34D5}';
IID__Database: TGUID = '{10020306-E260-11CF-AE68-00AA004A34D5}';
CLASS_Database: TGUID = '{10020300-E260-11CF-AE68-00AA004A34D5}';
IID_Tables: TGUID = '{10020403-E260-11CF-AE68-00AA004A34D5}';
IID__Table: TGUID = '{10020406-E260-11CF-AE68-00AA004A34D5}';
CLASS_Table: TGUID = '{10020400-E260-11CF-AE68-00AA004A34D5}';
IID_Columns: TGUID = '{10020503-E260-11CF-AE68-00AA004A34D5}';
IID__Column: TGUID = '{10020506-E260-11CF-AE68-00AA004A34D5}';
CLASS_Column: TGUID = '{10020500-E260-11CF-AE68-00AA004A34D5}';
IID_DRIDefault: TGUID = '{10022B06-E260-11CF-AE68-00AA004A34D5}';
IID_SQLObjectList: TGUID = '{10022806-E260-11CF-AE68-00AA004A34D5}';
IID_Keys: TGUID = '{10020F03-E260-11CF-AE68-00AA004A34D5}';
IID__Key: TGUID = '{10020F06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Key: TGUID = '{10020F00-E260-11CF-AE68-00AA004A34D5}';
IID_Names: TGUID = '{10021D03-E260-11CF-AE68-00AA004A34D5}';
IID_Indexes: TGUID = '{10020E03-E260-11CF-AE68-00AA004A34D5}';
IID__Index: TGUID = '{10020E06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Index: TGUID = '{10020E00-E260-11CF-AE68-00AA004A34D5}';
IID_QueryResults: TGUID = '{10022506-E260-11CF-AE68-00AA004A34D5}';
IID_Triggers: TGUID = '{10021003-E260-11CF-AE68-00AA004A34D5}';
IID__Trigger: TGUID = '{10021006-E260-11CF-AE68-00AA004A34D5}';
CLASS_Trigger: TGUID = '{10021000-E260-11CF-AE68-00AA004A34D5}';
IID_Checks: TGUID = '{10021703-E260-11CF-AE68-00AA004A34D5}';
IID__Check: TGUID = '{10021706-E260-11CF-AE68-00AA004A34D5}';
CLASS_Check: TGUID = '{10021700-E260-11CF-AE68-00AA004A34D5}';
IID_BulkCopySink: TGUID = '{10021C09-E260-11CF-AE68-00AA004A34D5}';
IID__BulkCopy: TGUID = '{10021C06-E260-11CF-AE68-00AA004A34D5}';
CLASS_BulkCopy: TGUID = '{10021C00-E260-11CF-AE68-00AA004A34D5}';
IID_NameList: TGUID = '{10022406-E260-11CF-AE68-00AA004A34D5}';
IID_Views: TGUID = '{10020703-E260-11CF-AE68-00AA004A34D5}';
IID__View: TGUID = '{10020706-E260-11CF-AE68-00AA004A34D5}';
CLASS_View: TGUID = '{10020700-E260-11CF-AE68-00AA004A34D5}';
IID_StoredProcedures: TGUID = '{10020D03-E260-11CF-AE68-00AA004A34D5}';
IID__StoredProcedure: TGUID = '{10020D06-E260-11CF-AE68-00AA004A34D5}';
CLASS_StoredProcedure: TGUID = '{10020D00-E260-11CF-AE68-00AA004A34D5}';
IID_Defaults: TGUID = '{10020903-E260-11CF-AE68-00AA004A34D5}';
IID__Default: TGUID = '{10020906-E260-11CF-AE68-00AA004A34D5}';
CLASS_Default: TGUID = '{10020900-E260-11CF-AE68-00AA004A34D5}';
IID_Rules: TGUID = '{10020A03-E260-11CF-AE68-00AA004A34D5}';
IID__Rule: TGUID = '{10020A06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Rule: TGUID = '{10020A00-E260-11CF-AE68-00AA004A34D5}';
IID_UserDefinedDatatypes: TGUID =
'{10020803-E260-11CF-AE68-00AA004A34D5}';
IID__UserDefinedDatatype: TGUID =
'{10020806-E260-11CF-AE68-00AA004A34D5}';
CLASS_UserDefinedDatatype: TGUID =
'{10020800-E260-11CF-AE68-00AA004A34D5}';
IID_Users: TGUID = '{10020B03-E260-11CF-AE68-00AA004A34D5}';
IID__User: TGUID = '{10020B06-E260-11CF-AE68-00AA004A34D5}';
CLASS_User: TGUID = '{10020B00-E260-11CF-AE68-00AA004A34D5}';
IID_Groups: TGUID = '{10020C03-E260-11CF-AE68-00AA004A34D5}';
IID__Group: TGUID = '{10020C06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Group: TGUID = '{10020C00-E260-11CF-AE68-00AA004A34D5}';
IID_SystemDatatypes: TGUID = '{10021A03-E260-11CF-AE68-00AA004A34D5}';
IID_SystemDatatype: TGUID = '{10021A06-E260-11CF-AE68-00AA004A34D5}';
IID_TransactionLog: TGUID = '{10022606-E260-11CF-AE68-00AA004A34D5}';
IID_LogFiles: TGUID = '{10022E03-E260-11CF-AE68-00AA004A34D5}';
IID__LogFile: TGUID = '{10022E06-E260-11CF-AE68-00AA004A34D5}';
CLASS_LogFile: TGUID = '{10022E00-E260-11CF-AE68-00AA004A34D5}';
IID_DBOption: TGUID = '{10022206-E260-11CF-AE68-00AA004A34D5}';
IID_DBObject: TGUID = '{10022106-E260-11CF-AE68-00AA004A34D5}';
IID_TransferSink: TGUID = '{10021E09-E260-11CF-AE68-00AA004A34D5}';
IID__Transfer: TGUID = '{10021E06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Transfer: TGUID = '{10021E00-E260-11CF-AE68-00AA004A34D5}';
IID_FileGroups: TGUID = '{10022C03-E260-11CF-AE68-00AA004A34D5}';
IID__FileGroup: TGUID = '{10022C06-E260-11CF-AE68-00AA004A34D5}';
CLASS_FileGroup: TGUID = '{10022C00-E260-11CF-AE68-00AA004A34D5}';
IID_DBFiles: TGUID = '{10022D03-E260-11CF-AE68-00AA004A34D5}';
IID__DBFile: TGUID = '{10022D06-E260-11CF-AE68-00AA004A34D5}';
CLASS_DBFile: TGUID = '{10022D00-E260-11CF-AE68-00AA004A34D5}';
IID_DatabaseRoles: TGUID = '{10023103-E260-11CF-AE68-00AA004A34D5}';
IID__DatabaseRole: TGUID = '{10023106-E260-11CF-AE68-00AA004A34D5}';
CLASS_DatabaseRole: TGUID = '{10023100-E260-11CF-AE68-00AA004A34D5}';
IID_FullTextCatalogs: TGUID = '{10023503-E260-11CF-AE68-00AA004A34D5}';
IID__FullTextCatalog: TGUID = '{10023506-E260-11CF-AE68-00AA004A34D5}';
CLASS_FullTextCatalog: TGUID = '{10023500-E260-11CF-AE68-00AA004A34D5}';
IID_BackupDevices: TGUID = '{10021103-E260-11CF-AE68-00AA004A34D5}';
IID__BackupDevice: TGUID = '{10021106-E260-11CF-AE68-00AA004A34D5}';
CLASS_BackupDevice: TGUID = '{10021100-E260-11CF-AE68-00AA004A34D5}';
IID_IntegratedSecurity: TGUID = '{10022A06-E260-11CF-AE68-00AA004A34D5}';
IID_Languages: TGUID = '{10021403-E260-11CF-AE68-00AA004A34D5}';
IID__Language: TGUID = '{10021406-E260-11CF-AE68-00AA004A34D5}';
CLASS_Language: TGUID = '{10021400-E260-11CF-AE68-00AA004A34D5}';
IID_RemoteServers: TGUID = '{10021503-E260-11CF-AE68-00AA004A34D5}';
IID__RemoteServer: TGUID = '{10021506-E260-11CF-AE68-00AA004A34D5}';
CLASS_RemoteServer: TGUID = '{10021500-E260-11CF-AE68-00AA004A34D5}';
IID_RemoteLogins: TGUID = '{10021603-E260-11CF-AE68-00AA004A34D5}';
IID__RemoteLogin: TGUID = '{10021606-E260-11CF-AE68-00AA004A34D5}';
CLASS_RemoteLogin: TGUID = '{10021600-E260-11CF-AE68-00AA004A34D5}';
IID_Logins: TGUID = '{10021303-E260-11CF-AE68-00AA004A34D5}';
IID__Login: TGUID = '{10021306-E260-11CF-AE68-00AA004A34D5}';
CLASS_Login: TGUID = '{10021300-E260-11CF-AE68-00AA004A34D5}';
IID_Registry: TGUID = '{10022706-E260-11CF-AE68-00AA004A34D5}';
IID_Configuration: TGUID = '{10022306-E260-11CF-AE68-00AA004A34D5}';
IID_ConfigValues: TGUID = '{10021B03-E260-11CF-AE68-00AA004A34D5}';
IID_ConfigValue: TGUID = '{10021B06-E260-11CF-AE68-00AA004A34D5}';
IID_JobServer: TGUID = '{10040406-E260-11CF-AE68-00AA004A34D5}';
IID_AlertSystem: TGUID = '{10040506-E260-11CF-AE68-00AA004A34D5}';
IID_Operators: TGUID = '{10040203-E260-11CF-AE68-00AA004A34D5}';
IID__Operator: TGUID = '{10040206-E260-11CF-AE68-00AA004A34D5}';
CLASS_Operator: TGUID = '{10040200-E260-11CF-AE68-00AA004A34D5}';
IID_Alerts: TGUID = '{10040603-E260-11CF-AE68-00AA004A34D5}';
IID__Alert: TGUID = '{10040606-E260-11CF-AE68-00AA004A34D5}';
CLASS_Alert: TGUID = '{10040600-E260-11CF-AE68-00AA004A34D5}';
IID_Jobs: TGUID = '{10040803-E260-11CF-AE68-00AA004A34D5}';
IID__Job: TGUID = '{10040806-E260-11CF-AE68-00AA004A34D5}';
CLASS_Job: TGUID = '{10040800-E260-11CF-AE68-00AA004A34D5}';
IID_JobSteps: TGUID = '{10040903-E260-11CF-AE68-00AA004A34D5}';
IID__JobStep: TGUID = '{10040906-E260-11CF-AE68-00AA004A34D5}';
CLASS_JobStep: TGUID = '{10040900-E260-11CF-AE68-00AA004A34D5}';
IID_JobSchedules: TGUID = '{10041603-E260-11CF-AE68-00AA004A34D5}';
IID__JobSchedule: TGUID = '{10041606-E260-11CF-AE68-00AA004A34D5}';
CLASS_JobSchedule: TGUID = '{10041600-E260-11CF-AE68-00AA004A34D5}';
IID_Schedule: TGUID = '{10041206-E260-11CF-AE68-00AA004A34D5}';
IID_TargetServers: TGUID = '{10041003-E260-11CF-AE68-00AA004A34D5}';
IID__TargetServer: TGUID = '{10041006-E260-11CF-AE68-00AA004A34D5}';
CLASS_TargetServer: TGUID = '{10041000-E260-11CF-AE68-00AA004A34D5}';
IID_TargetServerGroups: TGUID = '{10041103-E260-11CF-AE68-00AA004A34D5}';
IID__TargetServerGroup: TGUID = '{10041106-E260-11CF-AE68-00AA004A34D5}';
CLASS_TargetServerGroup: TGUID = '{10041100-E260-11CF-AE68-00AA004A34D5}';
IID_JobFilter: TGUID = '{10041306-E260-11CF-AE68-00AA004A34D5}';
IID_JobHistoryFilter: TGUID = '{10041406-E260-11CF-AE68-00AA004A34D5}';
IID_JobCategories: TGUID = '{10041503-E260-11CF-AE68-00AA004A34D5}';
IID__Category: TGUID = '{10041512-E260-11CF-AE68-00AA004A34D5}';
CLASS_Category: TGUID = '{10041500-E260-11CF-AE68-00AA004A34D5}';
IID_AlertCategories: TGUID = '{10041506-E260-11CF-AE68-00AA004A34D5}';
IID_OperatorCategories: TGUID = '{10041509-E260-11CF-AE68-00AA004A34D5}';
IID_BackupSink: TGUID = '{10021F09-E260-11CF-AE68-00AA004A34D5}';
IID__Backup: TGUID = '{10021F06-E260-11CF-AE68-00AA004A34D5}';
CLASS_Backup: TGUID = '{10021F00-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationSink: TGUID = '{10031009-E260-11CF-AE68-00AA004A34D5}';
IID__Replication: TGUID = '{10031006-E260-11CF-AE68-00AA004A34D5}';
IID_Publisher: TGUID = '{10030C06-E260-11CF-AE68-00AA004A34D5}';
IID_RegisteredSubscribers: TGUID =
'{10030903-E260-11CF-AE68-00AA004A34D5}';
IID__RegisteredSubscriber: TGUID =
'{10030906-E260-11CF-AE68-00AA004A34D5}';
CLASS_RegisteredSubscriber: TGUID =
'{10030900-E260-11CF-AE68-00AA004A34D5}';
IID__ReplicationSecurity: TGUID =
'{10031206-E260-11CF-AE68-00AA004A34D5}';
CLASS_ReplicationSecurity: TGUID =
'{10031200-E260-11CF-AE68-00AA004A34D5}';
IID_Subscriber: TGUID = '{10030D06-E260-11CF-AE68-00AA004A34D5}';
IID_Distributor: TGUID = '{10030E06-E260-11CF-AE68-00AA004A34D5}';
IID_DistributionPublishers: TGUID =
'{10030703-E260-11CF-AE68-00AA004A34D5}';
IID__DistributionPublisher: TGUID =
'{10030706-E260-11CF-AE68-00AA004A34D5}';
CLASS_DistributionPublisher: TGUID =
'{10030700-E260-11CF-AE68-00AA004A34D5}';
IID_DistributionPublications: TGUID =
'{10032103-E260-11CF-AE68-00AA004A34D5}';
IID__DistributionPublication: TGUID =
'{10032106-E260-11CF-AE68-00AA004A34D5}';
CLASS_DistributionPublication: TGUID =
'{10032100-E260-11CF-AE68-00AA004A34D5}';
IID_DistributionArticles: TGUID =
'{10033103-E260-11CF-AE68-00AA004A34D5}';
IID__DistributionArticle: TGUID =
'{10033106-E260-11CF-AE68-00AA004A34D5}';
CLASS_DistributionArticle: TGUID =
'{10033100-E260-11CF-AE68-00AA004A34D5}';
IID_DistributionSubscriptions: TGUID =
'{10034103-E260-11CF-AE68-00AA004A34D5}';
IID__DistributionSubscription: TGUID =
'{10034106-E260-11CF-AE68-00AA004A34D5}';
CLASS_DistributionSubscription: TGUID =
'{10034100-E260-11CF-AE68-00AA004A34D5}';
IID_DistributionDatabases: TGUID =
'{10031303-E260-11CF-AE68-00AA004A34D5}';
IID__DistributionDatabase: TGUID =
'{10031306-E260-11CF-AE68-00AA004A34D5}';
CLASS_DistributionDatabase: TGUID =
'{10031300-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationDatabases: TGUID =
'{10030A03-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationDatabase: TGUID = '{10030A06-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationTables: TGUID = '{10031403-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationTable: TGUID = '{10031406-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationStoredProcedures: TGUID =
'{10031603-E260-11CF-AE68-00AA004A34D5}';
IID_ReplicationStoredProcedure: TGUID =
'{10031606-E260-11CF-AE68-00AA004A34D5}';
IID_TransPublications: TGUID = '{10030103-E260-11CF-AE68-00AA004A34D5}';
IID__TransPublication: TGUID = '{10030106-E260-11CF-AE68-00AA004A34D5}';
CLASS_TransPublication: TGUID = '{10030100-E260-11CF-AE68-00AA004A34D5}';
IID_TransArticles: TGUID = '{10030203-E260-11CF-AE68-00AA004A34D5}';
IID__TransArticle: TGUID = '{10030206-E260-11CF-AE68-00AA004A34D5}';
CLASS_TransArticle: TGUID = '{10030200-E260-11CF-AE68-00AA004A34D5}';
IID_TransSubscriptions: TGUID = '{10030303-E260-11CF-AE68-00AA004A34D5}';
IID__TransSubscription: TGUID = '{10030306-E260-11CF-AE68-00AA004A34D5}';
CLASS_TransSubscription: TGUID = '{10030300-E260-11CF-AE68-00AA004A34D5}';
IID_MergePublications: TGUID = '{10030403-E260-11CF-AE68-00AA004A34D5}';
IID__MergePublication: TGUID = '{10030406-E260-11CF-AE68-00AA004A34D5}';
CLASS_MergePublication: TGUID = '{10030400-E260-11CF-AE68-00AA004A34D5}';
IID_MergeArticles: TGUID = '{10030503-E260-11CF-AE68-00AA004A34D5}';
IID__MergeArticle: TGUID = '{10030506-E260-11CF-AE68-00AA004A34D5}';
CLASS_MergeArticle: TGUID = '{10030500-E260-11CF-AE68-00AA004A34D5}';
IID_MergeSubsetFilters: TGUID = '{10035103-E260-11CF-AE68-00AA004A34D5}';
IID__MergeSubsetFilter: TGUID = '{10035106-E260-11CF-AE68-00AA004A34D5}';
CLASS_MergeSubsetFilter: TGUID = '{10035100-E260-11CF-AE68-00AA004A34D5}';
IID_MergeSubscriptions: TGUID = '{10030603-E260-11CF-AE68-00AA004A34D5}';
IID__MergeSubscription: TGUID = '{10030606-E260-11CF-AE68-00AA004A34D5}';
CLASS_MergeSubscription: TGUID = '{10030600-E260-11CF-AE68-00AA004A34D5}';
IID_TransPullSubscriptions: TGUID =
'{10030B03-E260-11CF-AE68-00AA004A34D5}';
IID__TransPullSubscription: TGUID =
'{10030B06-E260-11CF-AE68-00AA004A34D5}';
CLASS_TransPullSubscription: TGUID =
'{10030B00-E260-11CF-AE68-00AA004A34D5}';
IID_MergePullSubscriptions: TGUID =
'{10031103-E260-11CF-AE68-00AA004A34D5}';
IID__MergePullSubscription: TGUID =
'{10031106-E260-11CF-AE68-00AA004A34D5}';
CLASS_MergePullSubscription: TGUID =
'{10031100-E260-11CF-AE68-00AA004A34D5}';
CLASS_Replication: TGUID = '{10031000-E260-11CF-AE68-00AA004A34D5}';
IID_ServerRoles: TGUID = '{10022F03-E260-11CF-AE68-00AA004A34D5}';
IID__ServerRole: TGUID = '{10022F06-E260-11CF-AE68-00AA004A34D5}';
CLASS_ServerRole: TGUID = '{10022F00-E260-11CF-AE68-00AA004A34D5}';
IID_LinkedServers: TGUID = '{10023303-E260-11CF-AE68-00AA004A34D5}';
IID__LinkedServer: TGUID = '{10023306-E260-11CF-AE68-00AA004A34D5}';
CLASS_LinkedServer: TGUID = '{10023300-E260-11CF-AE68-00AA004A34D5}';
IID_LinkedServerLogins: TGUID = '{10023403-E260-11CF-AE68-00AA004A34D5}';
IID__LinkedServerLogin: TGUID = '{10023406-E260-11CF-AE68-00AA004A34D5}';
CLASS_LinkedServerLogin: TGUID = '{10023400-E260-11CF-AE68-00AA004A34D5}';
IID_FullTextService: TGUID = '{10023606-E260-11CF-AE68-00AA004A34D5}';
CLASS_SQLServer: TGUID = '{10020200-E260-11CF-AE68-00AA004A34D5}';
IID_ServerGroups: TGUID = '{10021803-E260-11CF-AE68-00AA004A34D5}';
IID__ServerGroup: TGUID = '{10021806-E260-11CF-AE68-00AA004A34D5}';
CLASS_ServerGroup: TGUID = '{10021800-E260-11CF-AE68-00AA004A34D5}';
IID_RegisteredServers: TGUID = '{10021903-E260-11CF-AE68-00AA004A34D5}';
IID__RegisteredServer: TGUID = '{10021906-E260-11CF-AE68-00AA004A34D5}';
CLASS_RegisteredServer: TGUID = '{10021900-E260-11CF-AE68-00AA004A34D5}';
IID_Permission: TGUID = '{10022906-E260-11CF-AE68-00AA004A34D5}';
IID__Restore: TGUID = '{10023203-E260-11CF-AE68-00AA004A34D5}';
IID_RestoreSink: TGUID = '{10023206-E260-11CF-AE68-00AA004A34D5}';
CLASS_Restore: TGUID = '{10023200-E260-11CF-AE68-00AA004A34D5}';
// *********************************************************************//
// Declaration of Enumerations defined in Type Library //
// *********************************************************************//
// SQLDMO_OBJECT_TYPE constants
type
SQLDMO_OBJECT_TYPE = TOleEnum;
const
SQLDMOObj_Unknown = $00004000;
SQLDMOObj_Application = $00000000;
SQLDMOObj_UserDefinedDatatype = $00000001;
SQLDMOObj_SystemTable = $00000002;
SQLDMOObj_View = $00000004;
SQLDMOObj_UserTable = $00000008;
SQLDMOObj_StoredProcedure = $00000010;
SQLDMOObj_Default = $00000040;
SQLDMOObj_Rule = $00000080;
SQLDMOObj_Trigger = $00000100;
SQLDMOObj_AllDatabaseUserObjects = $000001FD;
SQLDMOObj_AllDatabaseObjects = $000001FF;
SQLDMOObj_SystemDatatype = $00001000;
SQLDMOObj_User = $00002000;
SQLDMOObj_Group = $00003000;
SQLDMOObj_Index = $00004000;
SQLDMOObj_Key = $00005000;
SQLDMOObj_Column = $00006000;
SQLDMOObj_DBObject = $00007000;
SQLDMOObj_DBOption = $00008000;
SQLDMOObj_ProcedureParameter = $00009000;
SQLDMOObj_Permission = $0000A000;
SQLDMOObj_IntegratedSecurity = $0000B000;
SQLDMOObj_Check = $0000C000;
SQLDMOObj_DRIDefault = $0000D000;
SQLDMOObj_SQLServer = $00020000;
SQLDMOObj_Database = $00021000;
SQLDMOObj_BackupDevice = $00022000;
SQLDMOObj_Login = $00023000;
SQLDMOObj_Language = $00024000;
SQLDMOObj_RemoteServer = $00025000;
SQLDMOObj_RemoteLogin = $00026000;
SQLDMOObj_Configuration = $00027000;
SQLDMOObj_ConfigValue = $00028000;
SQLDMOObj_QueryResults = $00029000;
SQLDMOObj_TransactionLog = $0002A000;
SQLDMOObj_Registry = $0002B000;
SQLDMOObj_Transfer = $0002C000;
SQLDMOObj_Backup = $0002D000;
SQLDMOObj_AutoProperty = $0002E000;
SQLDMOObj_ServerGroup = $0002F000;
SQLDMOObj_RegisteredServer = $00031000;
SQLDMOObj_BulkCopy = $00032000;
SQLDMOObj_FileGroup = $00033000;
SQLDMOObj_DBFile = $00034000;
SQLDMOObj_LogFile = $00035000;
SQLDMOObj_ServerRole = $00036000;
SQLDMOObj_DatabaseRole = $00037000;
SQLDMOObj_Restore = $00038000;
SQLDMOObj_LinkedServer = $00039000;
SQLDMOObj_LinkedServerLogin = $00040000;
SQLDMOObj_FullTextCatalog = $00041000;
SQLDMOObj_FullTextService = $00042000;
SQLDMOObj_TransPublication = $00101000;
SQLDMOObj_TransArticle = $00102000;
SQLDMOObj_TransSubscription = $00103000;
SQLDMOObj_TransPullSubscription = $00104000;
SQLDMOObj_MergePublication = $00105000;
SQLDMOObj_MergeArticle = $00106000;
SQLDMOObj_MergeSubscription = $00107000;
SQLDMOObj_MergePullSubscription = $00108000;
SQLDMOObj_Replication = $00109000;
SQLDMOObj_Publisher = $0010A000;
SQLDMOObj_Subscriber = $0010B000;
SQLDMOObj_Distributor = $0010C000;
SQLDMOObj_ReplicationSecurity = $0010D000;
SQLDMOObj_DistributionPublisher = $0010E000;
SQLDMOObj_RegisteredSubscriber = $0010F000;
SQLDMOObj_ReplicationDatabase = $00110000;
SQLDMOObj_DistributionDatabase = $00111000;
SQLDMOObj_ReplicationTable = $00112000;
SQLDMOObj_ReplicationStoredProcedure = $00113000;
SQLDMOObj_DistributionPublication = $00114000;
SQLDMOObj_DistributionArticle = $00115000;
SQLDMOObj_DistributionSubscription = $00116000;
SQLDMOObj_MergeSubsetFilter = $00117000;
SQLDMOObj_AlertSystem = $00201000;
SQLDMOObj_JobServer = $00202000;
SQLDMOObj_Alert = $00203000;
SQLDMOObj_Operator = $00204000;
SQLDMOObj_Job = $00205000;
SQLDMOObj_JobStep = $00206000;
SQLDMOObj_TargetServer = $00207000;
SQLDMOObj_TargetServerGroup = $00208000;
SQLDMOObj_Category = $00209000;
SQLDMOObj_Schedule = $00210000;
SQLDMOObj_JobFilter = $00211000;
SQLDMOObj_JobHistoryFilter = $00212000;
SQLDMOObj_JobSchedule = $00213000;
SQLDMOObj_Last = $10000000;
// SQLDMO_KEY_TYPE constants
type
SQLDMO_KEY_TYPE = TOleEnum;
const
SQLDMOKey_Unknown = $00000000;
SQLDMOKey_Primary = $00000001;
SQLDMOKey_Unique = $00000002;
SQLDMOKey_Foreign = $00000003;
// SQLDMO_DEVICE_TYPE constants
type
SQLDMO_DEVICE_TYPE = TOleEnum;
const
SQLDMODevice_Unknown = $00000064;
SQLDMODevice_DiskDump = $00000002;
SQLDMODevice_FloppyADump = $00000003;
SQLDMODevice_FloppyBDump = $00000004;
SQLDMODevice_TapeDump = $00000005;
SQLDMODevice_PipeDump = $00000006;
SQLDMODevice_CDROM = $00000007;
// SQLDMO_PRIVILEGE_TYPE constants
type
SQLDMO_PRIVILEGE_TYPE = TOleEnum;
const
SQLDMOPriv_Unknown = $00000000;
SQLDMOPriv_Select = $00000001;
SQLDMOPriv_Insert = $00000002;
SQLDMOPriv_Update = $00000004;
SQLDMOPriv_Delete = $00000008;
SQLDMOPriv_Execute = $00000010;
SQLDMOPriv_References = $00000020;
SQLDMOPriv_AllObjectPrivs = $0000003F;
SQLDMOPriv_CreateTable = $00000080;
SQLDMOPriv_CreateDatabase = $00000100;
SQLDMOPriv_CreateView = $00000200;
SQLDMOPriv_CreateProcedure = $00000400;
SQLDMOPriv_DumpDatabase = $00000800;
SQLDMOPriv_CreateDefault = $00001000;
SQLDMOPriv_DumpTransaction = $00002000;
SQLDMOPriv_CreateRule = $00004000;
SQLDMOPriv_DumpTable = $00008000;
SQLDMOPriv_AllDatabasePrivs = $0000FF80;
// SQLDMO_PROCEDURE_TYPE constants
type
SQLDMO_PROCEDURE_TYPE = TOleEnum;
const
SQLDMOProc_Unknown = $00000000;
SQLDMOProc_Standard = $00000001;
SQLDMOProc_Extended = $00000002;
SQLDMOProc_Macro = $00000003;
SQLDMOProc_ReplicationFilter = $00000004;
// SQLDMO_TRIGGER_TYPE constants
type
SQLDMO_TRIGGER_TYPE = TOleEnum;
const
SQLDMOTrig_Unknown = $00000000;
SQLDMOTrig_Insert = $00000001;
SQLDMOTrig_Update = $00000002;
SQLDMOTrig_Delete = $00000004;
SQLDMOTrig_All = $00000007;
// SQLDMO_INDEX_TYPE constants
type
SQLDMO_INDEX_TYPE = TOleEnum;
const
SQLDMOIndex_Default = $00000000;
SQLDMOIndex_IgnoreDupKey = $00000001;
SQLDMOIndex_Unique = $00000002;
SQLDMOIndex_Clustered = $00000010;
SQLDMOIndex_PadIndex = $00000100;
SQLDMOIndex_SortedData = $00000200;
SQLDMOIndex_SortedDataReorg = $00002000;
SQLDMOIndex_DropExist = $00008000;
SQLDMOIndex_Valid = $0000A313;
SQLDMOIndex_Hypothetical = $00000020;
SQLDMOIndex_DRIPrimaryKey = $00000800;
SQLDMOIndex_DRIUniqueKey = $00001000;
SQLDMOIndex_DRIIndex = $00001800;
// SQLDMO_QUERY_DATATYPE constants
type
SQLDMO_QUERY_DATATYPE = TOleEnum;
const
SQLDMO_DTypeUnknown = $00000000;
SQLDMO_DTypeChar = $00000001;
SQLDMO_DTypeText = $FFFFFFFF;
SQLDMO_DTypeVarchar = $0000000C;
SQLDMO_DTypeVarBinary = $FFFFFFFD;
SQLDMO_DTypeBinary = $FFFFFFFE;
SQLDMO_DTypeImage = $FFFFFFFC;
SQLDMO_DTypeFloat4 = $00000007;
SQLDMO_DTypeFloat8 = $00000008;
SQLDMO_DTypeInt1 = $FFFFFFFA;
SQLDMO_DTypeInt2 = $00000005;
SQLDMO_DTypeInt4 = $00000004;
SQLDMO_DTypeMoney4 = $00000003;
SQLDMO_DTypeMoney = $00000003;
SQLDMO_DTypeDateTime = $FFFFFFFE;
SQLDMO_DTypeDateTime4 = $0000005D;
SQLDMO_DTypeBit = $FFFFFFF9;
SQLDMO_DTypeUChar = $FFFFFFF8;
SQLDMO_DTypeUVarchar = $FFFFFFF7;
SQLDMO_DTypeGUID = $FFFFFFF5;
SQLDMO_DTypeNText = $FFFFFFF6;
// SQLDMO_AUDIT_TYPE constants
type
SQLDMO_AUDIT_TYPE = TOleEnum;
const
SQLDMOAudit_None = $00000000;
SQLDMOAudit_Success = $00000001;
SQLDMOAudit_Failure = $00000002;
SQLDMOAudit_All = $00000003;
// SQLDMO_SECURITY_TYPE constants
type
SQLDMO_SECURITY_TYPE = TOleEnum;
const
SQLDMOSecurity_Min = $00000000;
SQLDMOSecurity_Normal = $00000000;
SQLDMOSecurity_Integrated = $00000001;
SQLDMOSecurity_Mixed = $00000002;
SQLDMOSecurity_Max = $00000002;
// SQLDMO_MEDIA_TYPE constants
type
SQLDMO_MEDIA_TYPE = TOleEnum;
const
SQLDMOMedia_Floppy = $00000001;
SQLDMOMedia_FixedDisk = $00000002;
SQLDMOMedia_Tape = $00000004;
SQLDMOMedia_CDROM = $00000008;
SQLDMOMedia_All = $0000000F;
// SQLDMO_PERFMON_TYPE constants
type
SQLDMO_PERFMON_TYPE = TOleEnum;
const
SQLDMOPerfmon_None = $000003E8;
SQLDMOPerfmon_MinSet = $00000000;
SQLDMOPerfmon_Continuous = $00000000;
SQLDMOPerfmon_OnDemand = $00000001;
SQLDMOPerfmon_MaxSet = $00000001;
// SQLDMO_DBSTATUS_TYPE constants
type
SQLDMO_DBSTATUS_TYPE = TOleEnum;
const
SQLDMODBStat_Normal = $00000000;
SQLDMODBStat_Loading = $00000020;
SQLDMODBStat_Recovering = $000000C0;
SQLDMODBStat_Suspect = $00000100;
SQLDMODBStat_Offline = $00000200;
SQLDMODBStat_Inaccessible = $000003E0;
SQLDMODBStat_EmergencyMode = $00008000;
SQLDMODBStat_All = $000083E0;
// SQLDMO_COPYDATA_TYPE constants
type
SQLDMO_COPYDATA_TYPE = TOleEnum;
const
SQLDMOCopyData_False = $00000000;
SQLDMOCopyData_Replace = $00000001;
SQLDMOCopyData_Append = $00000002;
// SQLDMO_DATAFILE_TYPE constants
type
SQLDMO_DATAFILE_TYPE = TOleEnum;
const
SQLDMODataFile_CommaDelimitedChar = $00000001;
SQLDMODataFile_Default = $00000001;
SQLDMODataFile_TabDelimitedChar = $00000002;
SQLDMODataFile_SpecialDelimitedChar = $00000003;
SQLDMODataFile_NativeFormat = $00000004;
SQLDMODataFile_UseFormatFile = $00000005;
// SQLDMO_STATUSINFO_TYPE constants
type
SQLDMO_STATUSINFO_TYPE = TOleEnum;
const
SQLDMOStatInfo_Unknown = $00000000;
SQLDMOStatInfo_DatabaseStatus = $00000001;
SQLDMOStatInfo_DatabaseSpace = $00000002;
SQLDMOStatInfo_AutoVerifyConnection = $00000004;
SQLDMOStatInfo_All = $00000007;
// SQLDMO_SCRIPT_TYPE constants
type
SQLDMO_SCRIPT_TYPE = TOleEnum;
const
SQLDMOScript_Default = $00000004;
SQLDMOScript_Drops = $00000001;
SQLDMOScript_ObjectPermissions = $00000002;
SQLDMOScript_PrimaryObject = $00000004;
SQLDMOScript_ClusteredIndexes = $00000008;
SQLDMOScript_Triggers = $00000010;
SQLDMOScript_DatabasePermissions = $00000020;
SQLDMOScript_Permissions = $00000022;
SQLDMOScript_ToFileOnly = $00000040;
SQLDMOScript_Bindings = $00000080;
SQLDMOScript_AppendToFile = $00000100;
SQLDMOScript_NoDRI = $00000200;
SQLDMOScript_UDDTsToBaseType = $00000400;
SQLDMOScript_IncludeIfNotExists = $00001000;
SQLDMOScript_NonClusteredIndexes = $00002000;
SQLDMOScript_Indexes = $00012008;
SQLDMOScript_Aliases = $00004000;
SQLDMOScript_NoCommandTerm = $00008000;
SQLDMOScript_DRIIndexes = $00010000;
SQLDMOScript_IncludeHeaders = $00020000;
SQLDMOScript_OwnerQualify = $00040000;
SQLDMOScript_TimestampToBinary = $00080000;
SQLDMOScript_SortedData = $00100000;
SQLDMOScript_SortedDataReorg = $00200000;
SQLDMOScript_TransferDefault = $000670FF;
SQLDMOScript_DRI_NonClustered = $00400000;
SQLDMOScript_DRI_Clustered = $00800000;
SQLDMOScript_DRI_Checks = $01000000;
SQLDMOScript_DRI_Defaults = $02000000;
SQLDMOScript_DRI_UniqueKeys = $04000000;
SQLDMOScript_DRI_ForeignKeys = $08000000;
SQLDMOScript_DRI_PrimaryKey = $10000000;
SQLDMOScript_DRI_AllKeys = $1C000000;
SQLDMOScript_DRI_AllConstraints = $1F000000;
SQLDMOScript_DRI_All = $1FC00000;
SQLDMOScript_DRIWithNoCheck = $20000000;
SQLDMOScript_NoIdentity = $40000000;
SQLDMOScript_UseQuotedIdentifiers = $80000000;
// SQLDMO_SCRIPT2_TYPE constants
type
SQLDMO_SCRIPT2_TYPE = TOleEnum;
const
SQLDMOScript2_Default = $00000000;
SQLDMOScript2_AnsiPadding = $00000001;
SQLDMOScript2_AnsiFile = $00000002;
SQLDMOScript2_UnicodeFile = $00000004;
SQLDMOScript2_NonStop = $00000008;
SQLDMOScript2_NoFG = $00000010;
SQLDMOScript2_MarkTriggers = $00000020;
SQLDMOScript2_OnlyUserTriggers = $00000040;
SQLDMOScript2_EncryptPWD = $00000080;
SQLDMOScript2_SeparateXPs = $00000100;
// SQLDMO_XFRSCRIPTMODE_TYPE constants
type
SQLDMO_XFRSCRIPTMODE_TYPE = TOleEnum;
const
SQLDMOXfrFile_Default = $00000001;
SQLDMOXfrFile_SummaryFiles = $00000001;
SQLDMOXfrFile_SingleFile = $00000002;
SQLDMOXfrFile_SingleFilePerObject = $00000004;
// SQLDMO_DEPENDENCY_TYPE constants
type
SQLDMO_DEPENDENCY_TYPE = TOleEnum;
const
SQLDMODep_Parents = $00000000;
SQLDMODep_FullHierarchy = $00010000;
SQLDMODep_OrderDescending = $00020000;
SQLDMODep_Children = $00040000;
SQLDMODep_ReturnInputObject = $00080000;
SQLDMODep_FirstLevelOnly = $00100000;
SQLDMODep_DRIOnly = $00200000;
SQLDMODep_Valid = $003F0000;
// SQLDMO_OBJSORT_TYPE constants
type
SQLDMO_OBJSORT_TYPE = TOleEnum;
const
SQLDMOObjSort_Name = $00000000;
SQLDMOObjSort_Type = $00000001;
SQLDMOObjSort_Owner = $00000002;
SQLDMOObjSort_Date = $00000003;
// SQLDMO_SVCSTATUS_TYPE constants
type
SQLDMO_SVCSTATUS_TYPE = TOleEnum;
const
SQLDMOSvc_Unknown = $00000000;
SQLDMOSvc_Running = $00000001;
SQLDMOSvc_Paused = $00000002;
SQLDMOSvc_Stopped = $00000003;
SQLDMOSvc_Starting = $00000004;
SQLDMOSvc_Stopping = $00000005;
SQLDMOSvc_Continuing = $00000006;
SQLDMOSvc_Pausing = $00000007;
// SQLDMO_SRVOPTION_TYPE constants
type
SQLDMO_SRVOPTION_TYPE = TOleEnum;
const
SQLDMOSrvOpt_Unknown = $00000000;
SQLDMOSrvOpt_RPC = $00000001;
SQLDMOSrvOpt_Publisher = $00000002;
SQLDMOSrvOpt_Subscriber = $00000004;
SQLDMOSrvOpt_Distributor = $00000008;
SQLDMOSrvOpt_DistPublisher = $00000010;
SQLDMOSrvOpt_RPC_out = $00000040;
SQLDMOSrvOpt_DataAccess = $00000080;
SQLDMOSrvOpt_CollationCompatible = $00000100;
SQLDMOSrvOpt_NonTransacted = $00000200;
SQLDMOSrvOpt_InProcess = $00000400;
SQLDMOSrvOpt_IndexAsAccessPath = $00000800;
SQLDMOSrvOpt_LevelZeroOnly = $00001000;
SQLDMOSrvOpt_NestedQueries = $00002000;
SQLDMOSrvOpt_DynamicParameters = $00004000;
// SQLDMO_TABLEATT_TYPE constants
type
SQLDMO_TABLEATT_TYPE = TOleEnum;
const
SQLDMOTabAtt_Identity = $00000001;
SQLDMOTabAtt_SystemObject = $00000002;
SQLDMOTabAtt_ForeignKey = $00000004;
SQLDMOTabAtt_Referenced = $00000008;
SQLDMOTabAtt_Published = $00000020;
SQLDMOTabAtt_Replicated = $00000040;
SQLDMOTabAtt_Check = $00000080;
SQLDMOTabAtt_Replica = $00000100;
SQLDMOTabAtt_PrimaryKey = $00000200;
SQLDMOTabAtt_Unique = $00000400;
SQLDMOTabAtt_Default = $00000800;
SQLDMOTabAtt_ReplCheck = $00001000;
SQLDMOTabAtt_HasConstraint = $00001C84;
// SQLDMO_INTSECLOGIN_TYPE constants
type
SQLDMO_INTSECLOGIN_TYPE = TOleEnum;
const
SQLDMOIntSecLogin_Unknown = $00000000;
SQLDMOIntSecLogin_Min = $00000001;
SQLDMOIntSecLogin_Admin = $00000001;
SQLDMOIntSecLogin_User = $00000002;
SQLDMOIntSecLogin_Replication = $00000003;
SQLDMOIntSecLogin_Max = $00000003;
// SQLDMO_VERIFYCONN_TYPE constants
type
SQLDMO_VERIFYCONN_TYPE = TOleEnum;
const
SQLDMOConn_LastState = $00000001;
SQLDMOConn_CurrentState = $00000002;
SQLDMOConn_ReconnectIfDead = $00000006;
SQLDMOConn_Valid = $00000007;
// SQLDMO_EXEC_TYPE constants
type
SQLDMO_EXEC_TYPE = TOleEnum;
const
SQLDMOExec_Default = $00000000;
SQLDMOExec_NoCommandTerm = $00000001;
SQLDMOExec_ContinueOnError = $00000002;
SQLDMOExec_NoExec = $00000004;
SQLDMOExec_ParseOnly = $00000008;
SQLDMOExec_QI_ON = $00000010;
// SQLDMO_CONFIGVALUE_TYPE constants
type
SQLDMO_CONFIGVALUE_TYPE = TOleEnum;
const
SQLDMOConfig_RecoveryInterval = $00000065;
SQLDMOConfig_AllowUpdates = $00000066;
SQLDMOConfig_UserConnections = $00000067;
SQLDMOConfig_Locks = $0000006A;
SQLDMOConfig_OpenObjects = $0000006B;
SQLDMOConfig_FillFactor = $0000006D;
SQLDMOConfig_NestedTriggers = $00000073;
SQLDMOConfig_RemoteAccess = $00000075;
SQLDMOConfig_DefaultLanguage = $0000007C;
SQLDMOConfig_LanguageInCache = $0000007D;
SQLDMOConfig_MaxAsyncIO = $000001F6;
SQLDMOConfig_MaxWorkerThreads = $000001F7;
SQLDMOConfig_NetworkPacketSize = $000001F9;
SQLDMOConfig_ShowAdvancedOption = $00000206;
SQLDMOConfig_RemoteProcTrans = $0000021E;
SQLDMOConfig_RemoteConnTimeout = $0000021F;
SQLDMOConfig_TimeSlice = $00000456;
SQLDMOConfig_DefaultSortorderId = $00000463;
SQLDMOConfig_SpinCounter = $000005EA;
SQLDMOConfig_PriorityBoost = $000005ED;
SQLDMOConfig_RemoteLoginTimeout = $000005EF;
SQLDMOConfig_RemoteQueryTimeout = $000005F0;
SQLDMOConfig_CursorThreshold = $000005FB;
SQLDMOConfig_SetWorkingSetSize = $000005FC;
SQLDMOConfig_ResourceTimeout = $000005FD;
SQLDMOConfig_UserOptions = $000005FE;
SQLDMOConfig_ProcessorAffinityMask = $000005FF;
SQLDMOConfig_MaxTextReplSize = $00000600;
SQLDMOConfig_UnicodeLocalID = $00000464;
SQLDMOConfig_UnicodeComparisonStyle = $00000465;
SQLDMOConfig_IndexCreateMem = $000005E1;
SQLDMOConfig_MediaRetention = $00000601;
SQLDMOConfig_CostThresholdForParallelism = $00000602;
SQLDMOConfig_MaxDegreeOfParallelism = $00000603;
SQLDMOConfig_MimMemoryPerQuery = $00000604;
SQLDMOConfig_MaxQueryWait = $00000605;
SQLDMOConfig_VLMSize = $00000606;
SQLDMOConfig_MinMemory = $00000607;
SQLDMOConfig_MaxMemory = $00000608;
SQLDMOConfig_QueryMaxTime = $00000609;
SQLDMOConfig_LightweightPooling = $0000060A;
// SQLDMO_SRVUSERPROFILE_TYPE constants
type
SQLDMO_SRVUSERPROFILE_TYPE = TOleEnum;
const
SQLDMOSrvUserProf_None = $00000000;
SQLDMOSrvUserProf_SaLogin = $00000001;
SQLDMOSrvUserProf_CreateDatabase = $00000002;
SQLDMOSrvUserProf_CreateXP = $00000004;
SQLDMOSrvUserProf_AllProfileBits = $00000007;
// SQLDMO_DBUSERPROFILE_TYPE constants
type
SQLDMO_DBUSERPROFILE_TYPE = TOleEnum;
const
SQLDMODbUserProf_None = $00000000;
SQLDMODbUserProf_DboLogin = $00000001;
SQLDMODbUserProf_CreateTable = $00000002;
SQLDMODbUserProf_CreateView = $00000004;
SQLDMODbUserProf_CreateProcedure = $00000008;
SQLDMODbUserProf_DumpDatabase = $00000010;
SQLDMODbUserProf_CreateDefault = $00000020;
SQLDMODbUserProf_DumpTransaction = $00000040;
SQLDMODbUserProf_CreateRule = $00000080;
SQLDMODbUserProf_DumpTable = $00000100;
SQLDMODbUserProf_AllProfileBits = $000001FF;
SQLDMODbUserProf_InvalidLogin = $40000000;
SQLDMODbUserProf_InaccessibleDb = $80000000;
SQLDMODbUserProf_DbNotAvailable = $C0000000;
// SQLDMO_OS_TYPE constants
type
SQLDMO_OS_TYPE = TOleEnum;
const
SQLDMO_WIN95 = $00000001;
SQLDMO_WINNT = $00000002;
// SQLDMO_PACKAGE_TYPE constants
type
SQLDMO_PACKAGE_TYPE = TOleEnum;
const
SQLDMO_Unknown = $00000000;
SQLDMO_DESKTOP = $00000001;
SQLDMO_STANDARD = $00000002;
SQLDMO_ENTERPRISE = $00000003;
// SQLDMO_CONSTANTS_TYPE constants
type
SQLDMO_CONSTANTS_TYPE = TOleEnum;
const
SQLDMO_NOENDDATE = $05F5BEBF;
SQLDMO_NOENDTIME = $000399B7;
SQLDMO_USEEXISTINGFILLFACTOR = $00000000;
// SQLDMO_LOGIN_TYPE constants
type
SQLDMO_LOGIN_TYPE = TOleEnum;
const
SQLDMOLogin_NTUser = $00000000;
SQLDMOLogin_NTGroup = $00000001;
SQLDMOLogin_Standard = $00000002;
// SQLDMO_ROLE_TYPE constants
type
SQLDMO_ROLE_TYPE = TOleEnum;
const
SQLDMORole_Server = $00000001;
SQLDMORole_Database = $00000002;
SQLDMORole_All = $00000003;
// SQLDMO_GRANTED_TYPE constants
type
SQLDMO_GRANTED_TYPE = TOleEnum;
const
SQLDMOGranted_GrantGrant = $000000CC;
SQLDMOGranted_Grant = $000000CD;
SQLDMOGranted_Deny = $000000CE;
// SQLDMO_BACKUP_LOG_TYPE constants
type
SQLDMO_BACKUP_LOG_TYPE = TOleEnum;
const
SQLDMOBackup_Log_NoTruncate = $00000000;
SQLDMOBackup_Log_Truncate = $00000001;
SQLDMOBackup_Log_TruncateNoLog = $00000002;
// SQLDMO_BACKUP_TYPE constants
type
SQLDMO_BACKUP_TYPE = TOleEnum;
const
SQLDMOBackup_Database = $00000000;
SQLDMOBackup_Incremental = $00000001;
SQLDMOBackup_Files = $00000002;
SQLDMOBackup_Log = $00000003;
// SQLDMO_RESTORE_TYPE constants
type
SQLDMO_RESTORE_TYPE = TOleEnum;
const
SQLDMORestore_Database = $00000000;
SQLDMORestore_Files = $00000001;
SQLDMORestore_Log = $00000002;
// SQLDMO_DBUSERROLE_TYPE constants
type
SQLDMO_DBUSERROLE_TYPE = TOleEnum;
const
SQLDMORole_db_None = $00000000;
SQLDMORole_dbcreator = $00000001;
SQLDMORole_diskadmin = $00000002;
SQLDMORole_processadmin = $00000004;
SQLDMORole_securityadmin = $00000008;
SQLDMORole_serveradmin = $00000010;
SQLDMORole_setupadmin = $00000020;
SQLDMORole_sysadmin = $00000040;
SQLDMORole_db_accessadmin = $00000080;
SQLDMORole_db_datareader = $00000100;
SQLDMORole_db_ddladmin = $00000200;
SQLDMORole_db_denydatareader = $00000400;
SQLDMORole_db_denydatawriter = $00000800;
SQLDMORole_db_backupoperator = $00001000;
SQLDMORole_db_owner = $00002000;
SQLDMORole_db_securityadmin = $00004000;
SQLDMORole_db_datawriter = $00008000;
// SQLDMO_GROWTH_TYPE constants
type
SQLDMO_GROWTH_TYPE = TOleEnum;
const
SQLDMOGrowth_MB = $00000000;
SQLDMOGrowth_Percent = $00000001;
SQLDMOGrowth_Invalid = $00000063;
// SQLDMO_STAT_SCAN_TYPE constants
type
SQLDMO_STAT_SCAN_TYPE = TOleEnum;
const
SQLDMOStatistic_Sample = $00000000;
SQLDMOStatistic_Percent = $00000001;
SQLDMOStatistic_Rows = $00000002;
SQLDMOStatistic_FullScan = $00000003;
// SQLDMO_STAT_AFFECT_TYPE constants
type
SQLDMO_STAT_AFFECT_TYPE = TOleEnum;
const
SQLDMOStatistic_AffectIndex = $00000000;
SQLDMOStatistic_AffectColumn = $00000001;
SQLDMOStatistic_AffectAll = $00000002;
// SQLDMO_FULLTEXTSTATUS_TYPE constants
type
SQLDMO_FULLTEXTSTATUS_TYPE = TOleEnum;
const
SQLDMOFullText_Idle = $00000000;
SQLDMOFullText_CrawlinProgress = $00000001;
SQLDMOFullText_Paused = $00000002;
SQLDMOFullText_Throttled = $00000003;
SQLDMOFullText_Recovering = $00000004;
SQLDMOFullText_Shutdown = $00000005;
SQLDMOFullText_Incremental = $00000006;
SQLDMOFullText_UpdatingIndex = $00000007;
// SQLDMO_FULLTEXT_START_TYPE constants
type
SQLDMO_FULLTEXT_START_TYPE = TOleEnum;
const
SQLDMOFullText_Full = $00000000;
SQLDMOFullText_Inc = $00000001;
// SQLDMO_LINKEDTABLE_TYPE constants
type
SQLDMO_LINKEDTABLE_TYPE = TOleEnum;
const
SQLDMOLinkedTable_Default = $00000000;
SQLDMOLinkedTable_Alias = $00000001;
SQLDMOLinkedTable_GlobalTemporary = $00000002;
SQLDMOLinkedTable_LocalTemporary = $00000003;
SQLDMOLinkedTable_SystemTable = $00000004;
SQLDMOLinkedTable_Table = $00000005;
SQLDMOLinkedTable_View = $00000006;
// SQLDMO_SQL_VER constants
type
SQLDMO_SQL_VER = TOleEnum;
const
SQLDMOSQLVer_Unknown = $00000000;
SQLDMOSQLVer_Pre_60 = $00000001;
SQLDMOSQLVer_60 = $00000002;
SQLDMOSQLVer_65 = $00000004;
SQLDMOSQLVer_70 = $00000008;
// SQLDMO_DBCC_REPAIR_TYPE constants
type
SQLDMO_DBCC_REPAIR_TYPE = TOleEnum;
const
SQLDMORepair_None = $00000000;
SQLDMORepair_Fast = $00000001;
SQLDMORepair_Rebuild = $00000002;
SQLDMORepair_Allow_DataLoss = $00000003;
// SQLDMO_BCP_CODEPAGE_TYPE constants
type
SQLDMO_BCP_CODEPAGE_TYPE = TOleEnum;
const
SQLDMOBCP_RAW = $FFFFFFFF;
SQLDMOBCP_ACP = $00000000;
SQLDMOBCP_OEM = $00000001;
SQLDMOBCP_User = $00000002;
// SQLDMO_SERVERBCP_DATAFILE_TYPE constants
type
SQLDMO_SERVERBCP_DATAFILE_TYPE = TOleEnum;
const
SQLDMOBCPDataFile_Char = $00000001;
SQLDMOBCPDataFile_Default = $00000001;
SQLDMOBCPDataFile_Native = $00000002;
SQLDMOBCPDataFile_WideChar = $00000004;
SQLDMOBCPDataFile_WideNative = $00000008;
// SQLDMO_COMP_LEVEL_TYPE constants
type
SQLDMO_COMP_LEVEL_TYPE = TOleEnum;
const
SQLDMOCompLevel_70 = $00000001;
SQLDMOCompLevel_65 = $00000002;
SQLDMOCompLevel_60 = $00000003;
SQLDMOCompLevel_Unknown = $00000009;
// SQLDMO_SUBSCRIBER_TYPE constants
type
SQLDMO_SUBSCRIBER_TYPE = TOleEnum;
const
SQLDMOSubInfo_SQLServer = $00000000;
SQLDMOSubInfo_ODBCDatasource = $00000001;
SQLDMOSubInfo_JetDatabase = $00000002;
SQLDMOSubInfo_OLEDBDatasource = $00000003;
// SQLDMO_INITIALSYNC_TYPE constants
type
SQLDMO_INITIALSYNC_TYPE = TOleEnum;
const
SQLDMOInitSync_Unknown = $0000000A;
SQLDMOInitSync_Min = $00000000;
SQLDMOInitSync_Default = $00000000;
SQLDMOInitSync_BCPNative = $00000000;
SQLDMOInitSync_BCPChar = $00000001;
SQLDMOInitSync_Max = $00000001;
// SQLDMO_REPFREQ_TYPE constants
type
SQLDMO_REPFREQ_TYPE = TOleEnum;
const
SQLDMORepFreq_Unknown = $000003E8;
SQLDMORepFreq_Min = $00000000;
SQLDMORepFreq_Continuous = $00000000;
SQLDMORepFreq_Snapshot = $00000001;
SQLDMORepFreq_Max = $00000001;
// SQLDMO_PUBLICATION_TYPE constants
type
SQLDMO_PUBLICATION_TYPE = TOleEnum;
const
SQLDMOPublication_Unknown = $000003E8;
SQLDMOPublication_Min = $00000000;
SQLDMOPublication_Transactional = $00000000;
SQLDMOPublication_Snapshot = $00000001;
SQLDMOPublication_Merge = $00000002;
SQLDMOPublication_Max = $00000001;
// SQLDMO_ARTICLE_TYPE constants
type
SQLDMO_ARTICLE_TYPE = TOleEnum;
const
SQLDMORep_Min = $00000000;
SQLDMORep_LogBased = $00000001;
SQLDMORep_ManualFilterProc = $00000002;
SQLDMORep_LogBasedManualFilterProc = $00000003;
SQLDMORep_ManualSyncView = $00000004;
SQLDMORep_LogBasedManualSyncView = $00000005;
SQLDMORep_LogBasedVerticalPartition = $00000006;
SQLDMORep_LogBasedManualBoth = $00000007;
SQLDMORep_ProcExecution = $00000008;
SQLDMORep_SerializableProcExecution = $00000018;
SQLDMORep_TableBased = $0000000A;
SQLDMORep_Max = $00000018;
// SQLDMO_SUBSYNC_TYPE constants
type
SQLDMO_SUBSYNC_TYPE = TOleEnum;
const
SQLDMOSubSync_Unknown = $000003E8;
SQLDMOSubSync_Manual = $00000000;
SQLDMOSubSync_Min = $00000001;
SQLDMOSubSync_Auto = $00000001;
SQLDMOSubSync_Default = $00000001;
SQLDMOSubSync_None = $00000002;
SQLDMOSubSync_Max = $00000002;
// SQLDMO_PREARTICLE_TYPE constants
type
SQLDMO_PREARTICLE_TYPE = TOleEnum;
const
SQLDMOPreArt_Min = $00000000;
SQLDMOPreArt_None = $00000000;
SQLDMOPreArt_DropTable = $00000001;
SQLDMOPreArt_DeleteRows = $00000002;
SQLDMOPreArt_TruncateTable = $00000003;
SQLDMOPreArt_Max = $00000003;
// SQLDMO_ARTSTATUS_TYPE constants
type
SQLDMO_ARTSTATUS_TYPE = TOleEnum;
const
SQLDMOArtStat_Min = $00000000;
SQLDMOArtStat_Inactive = $00000000;
SQLDMOArtStat_Unsynced = $00000001;
SQLDMOArtStat_Active = $00000002;
SQLDMOArtStat_Conflicts = $00000003;
SQLDMOArtStat_Errors = $00000004;
SQLDMOArtStat_Max = $00000004;
// SQLDMO_SUBSTATUS_TYPE constants
type
SQLDMO_SUBSTATUS_TYPE = TOleEnum;
const
SQLDMOSubStat_Unknown = $000003E8;
SQLDMOSubStat_Default = $000003E8;
SQLDMOSubStat_Min = $00000000;
SQLDMOSubStat_Inactive = $00000000;
SQLDMOSubStat_Unsynced = $00000001;
SQLDMOSubStat_Active = $00000002;
SQLDMOSubStat_Max = $00000002;
// SQLDMO_PUBSTATUS_TYPE constants
type
SQLDMO_PUBSTATUS_TYPE = TOleEnum;
const
SQLDMOPubStat_Unknown = $000003E8;
SQLDMOPubStat_Default = $000003E8;
SQLDMOPubStat_Min = $00000000;
SQLDMOPubStat_Inactive = $00000000;
SQLDMOPubStat_Active = $00000001;
SQLDMOPubStat_Max = $00000001;
// SQLDMO_REPLICATION_TYPE constants
type
SQLDMO_REPLICATION_TYPE = TOleEnum;
const
SQLDMORepType_Unknown = $00000100;
SQLDMORepType_Transactional = $00000001;
SQLDMORepType_Merge = $00000002;
SQLDMORepType_TransactionalMerge = $00000003;
SQLDMORepType_Default = $00000001;
// SQLDMO_RESOLVECONFLICT_TYPE constants
type
SQLDMO_RESOLVECONFLICT_TYPE = TOleEnum;
const
SQLDMOResolveConflict_Unknown = $00000100;
SQLDMOResolveConflict_Resubmit = $00000001;
SQLDMOResolveConflict_Discard = $00000002;
SQLDMOResolveConflict_Default = $00000001;
// SQLDMO_TRANSUBSCRIBER_TYPE constants
type
SQLDMO_TRANSUBSCRIBER_TYPE = TOleEnum;
const
SQLDMOTranSubscriber_Unknown = $00000100;
SQLDMOTranSubscriber_Min = $00000000;
SQLDMOTranSubscriber_ReadOnly = $00000000;
SQLDMOTranSubscriber_Synchronous = $00000001;
SQLDMOTranSubscriber_Default = $00000000;
SQLDMOTranSubscriber_Max = $00000001;
// SQLDMO_MERGESUBSCRIBER_TYPE constants
type
SQLDMO_MERGESUBSCRIBER_TYPE = TOleEnum;
const
SQLDMOMergeSubscriber_Unknown = $00000100;
SQLDMOMergeSubscriber_Min = $00000001;
SQLDMOMergeSubscriber_Global = $00000001;
SQLDMOMergeSubscriber_Local = $00000002;
SQLDMOMergeSubscriber_Anonymous = $00000003;
SQLDMOMergeSubscriber_Republishing = $00000004;
SQLDMOMergeSubscriber_Default = $00000002;
SQLDMOMergeSubscriber_Max = $00000004;
// SQLDMO_REPSCRIPT_TYPE constants
type
SQLDMO_REPSCRIPT_TYPE = TOleEnum;
const
SQLDMORepScript_Default = $00000100;
SQLDMORepScript_NoSubscription = $00000080;
SQLDMORepScript_InstallDistributor = $00000100;
SQLDMORepScript_UninstallDistributor = $00000200;
SQLDMORepScript_InstallPublisher = $00000400;
SQLDMORepScript_UninstallPublisher = $00000800;
SQLDMORepScript_ToFileOnly = $00001000;
SQLDMORepScript_AppendToFile = $00002000;
SQLDMORepScript_Creation = $00004000;
SQLDMORepScript_Deletion = $00008000;
SQLDMORepScript_PublicationCreation = $00010000;
SQLDMORepScript_PublicationDeletion = $00020000;
SQLDMORepScript_SubscriptionCreation = $00040000;
SQLDMORepScript_SubscriptionDeletion = $00080000;
SQLDMORepScript_InstallReplication = $00100000;
SQLDMORepScript_UninstallReplication = $00200000;
SQLDMORepScript_EnableReplication = $00400000;
SQLDMORepScript_DisableReplication = $00800000;
SQLDMORepScript_AnsiFile = $01000000;
SQLDMORepScript_UnicodeFile = $02000000;
SQLDMORepScript_EnableReplicationDB = $04000000;
SQLDMORepScript_DisableReplicationDB = $08000000;
SQLDMORepScript_NoCommandTerm = $10000000;
// SQLDMO_CREATIONSCRIPT_TYPE constants
type
SQLDMO_CREATIONSCRIPT_TYPE = TOleEnum;
const
SQLDMOCreationScript_DisableScripting = $00000000;
SQLDMOCreationScript_PrimaryObject = $00000001;
SQLDMOCreationScript_CustomProcs = $00000002;
SQLDMOCreationScript_ClusteredIndexes = $00000010;
SQLDMOCreationScript_UDDTsToBaseTypes = $00000020;
SQLDMOCreationScript_NonClusteredIndexes = $00000040;
SQLDMOCreationScript_DRI_PrimaryKey = $00000080;
// SQLDMO_COMMANDOPTION_TYPE constants
type
SQLDMO_COMMANDOPTION_TYPE = TOleEnum;
const
SQLDMOCommandOption_IncludeInsertColumnNames = $00000008;
SQLDMOCommandOption_BinaryParameters = $00000010;
// SQLDMO_SUBSCRIPTION_TYPE constants
type
SQLDMO_SUBSCRIPTION_TYPE = TOleEnum;
const
SQLDMOSubscription_Unknown = $00000100;
SQLDMOSubscription_Min = $00000000;
SQLDMOSubscription_Push = $00000000;
SQLDMOSubscription_Pull = $00000001;
SQLDMOSubscription_Anonymous = $00000002;
SQLDMOSubscription_All = $00000003;
SQLDMOSubscription_Default = $00000000;
SQLDMOSubscription_Max = $00000002;
// SQLDMO_PUBATTRIB_TYPE constants
type
SQLDMO_PUBATTRIB_TYPE = TOleEnum;
const
SQLDMOPubAttrib_Unknown = $00000100;
SQLDMOPubAttrib_Min = $00000000;
SQLDMOPubAttrib_AllowPush = $00000001;
SQLDMOPubAttrib_AllowPull = $00000002;
SQLDMOPubAttrib_AllowAnonymous = $00000004;
SQLDMOPubAttrib_InternetEnabled = $00000008;
SQLDMOPubAttrib_ImmediateSync = $00000010;
SQLDMOPubAttrib_IndependentAgent = $00000020;
SQLDMOPubAttrib_Default = $00000001;
SQLDMOPubAttrib_Valid = $0000003F;
// SQLDMO_TASKSTATUS_TYPE constants
type
SQLDMO_TASKSTATUS_TYPE = TOleEnum;
const
SQLDMOTask_Pending = $00000000;
SQLDMOTask_Starting = $00000001;
SQLDMOTask_Succeeded = $00000002;
SQLDMOTask_Running = $00000003;
SQLDMOTask_Idle = $00000004;
SQLDMOTask_Retry = $00000005;
SQLDMOTask_Failed = $00000006;
// SQLDMO_SESSION_TYPE constants
type
SQLDMO_SESSION_TYPE = TOleEnum;
const
SQLDMOSession_Unknown = $00000100;
SQLDMOSession_All = $00000001;
SQLDMOSession_Errors = $00000002;
// SQLDMO_REPLAGENT_TYPE constants
type
SQLDMO_REPLAGENT_TYPE = TOleEnum;
const
SQLDMOReplAgent_Default = $00000000;
SQLDMOReplAgent_All = $00000000;
SQLDMOReplAgent_Snapshot = $00000001;
SQLDMOReplAgent_LogReader = $00000002;
SQLDMOReplAgent_Distribution = $00000003;
SQLDMOReplAgent_Merge = $00000004;
// SQLDMO_REPLSECURITY_TYPE constants
type
SQLDMO_REPLSECURITY_TYPE = TOleEnum;
const
SQLDMOReplSecurity_Min = $00000000;
SQLDMOReplSecurity_Normal = $00000000;
SQLDMOReplSecurity_Integrated = $00000001;
SQLDMOReplSecurity_PredefinedServer = $00000002;
SQLDMOReplSecurity_Max = $00000002;
// SQLDMO_REPLCONSTANTS_TYPE constants
type
SQLDMO_REPLCONSTANTS_TYPE = TOleEnum;
const
SQLDMO_DEFAULTRETENTION = $0000003C;
// SQLDMO_COMPLETION_TYPE constants
type
SQLDMO_COMPLETION_TYPE = TOleEnum;
const
SQLDMOComp_Unknown = $00001000;
SQLDMOComp_None = $00000000;
SQLDMOComp_Success = $00000001;
SQLDMOComp_Failure = $00000002;
SQLDMOComp_Always = $00000003;
SQLDMOComp_All = $00000006;
// SQLDMO_JOBOUTCOME_TYPE constants
type
SQLDMO_JOBOUTCOME_TYPE = TOleEnum;
const
SQLDMOJobOutcome_Failed = $00000000;
SQLDMOJobOutcome_Succeeded = $00000001;
SQLDMOJobOutcome_Cancelled = $00000003;
SQLDMOJobOutcome_InProgress = $00000004;
SQLDMOJobOutcome_Unknown = $00000005;
// SQLDMO_EVENT_TYPE constants
type
SQLDMO_EVENT_TYPE = TOleEnum;
const
SQLDMOEvent_Unknown = $00000000;
SQLDMOEvent_Info = $00000001;
SQLDMOEvent_Warning = $00000002;
SQLDMOEvent_Error = $00000004;
SQLDMOEvent_AuditSuccess = $00000008;
SQLDMOEvent_AuditFailure = $00000010;
SQLDMOEvent_All = $0000001F;
// SQLDMO_FREQUENCY_TYPE constants
type
SQLDMO_FREQUENCY_TYPE = TOleEnum;
const
SQLDMOFreq_Unknown = $00000000;
SQLDMOFreq_OneTime = $00000001;
SQLDMOFreq_Daily = $00000004;
SQLDMOFreq_Weekly = $00000008;
SQLDMOFreq_Monthly = $00000010;
SQLDMOFreq_MonthlyRelative = $00000020;
SQLDMOFreq_Autostart = $00000040;
SQLDMOFreq_OnIdle = $00000080;
SQLDMOFreq_Valid = $000000FF;
// SQLDMO_FREQSUB_TYPE constants
type
SQLDMO_FREQSUB_TYPE = TOleEnum;
const
SQLDMOFreqSub_Unknown = $00000000;
SQLDMOFreqSub_Once = $00000001;
SQLDMOFreqSub_Minute = $00000004;
SQLDMOFreqSub_Hour = $00000008;
SQLDMOFreqSub_Valid = $0000000D;
// SQLDMO_FREQRELATIVE_TYPE constants
type
SQLDMO_FREQRELATIVE_TYPE = TOleEnum;
const
SQLDMOFreqRel_Unknown = $00000000;
SQLDMOFreqRel_First = $00000001;
SQLDMOFreqRel_Second = $00000002;
SQLDMOFreqRel_Third = $00000004;
SQLDMOFreqRel_Fourth = $00000008;
SQLDMOFreqRel_Last = $00000010;
SQLDMOFreqRel_Valid = $0000001F;
// SQLDMO_WEEKDAY_TYPE constants
type
SQLDMO_WEEKDAY_TYPE = TOleEnum;
const
SQLDMOWeek_Unknown = $00000000;
SQLDMOWeek_Sunday = $00000001;
SQLDMOWeek_Monday = $00000002;
SQLDMOWeek_Tuesday = $00000004;
SQLDMOWeek_Wednesday = $00000008;
SQLDMOWeek_Thursday = $00000010;
SQLDMOWeek_Friday = $00000020;
SQLDMOWeek_Saturday = $00000040;
SQLDMOWeek_WeekDays = $0000003E;
SQLDMOWeek_WeekEnds = $00000041;
SQLDMOWeek_EveryDay = $0000007F;
// SQLDMO_MONTHDAY_TYPE constants
type
SQLDMO_MONTHDAY_TYPE = TOleEnum;
const
SQLDMOMonth_Unknown = $00000000;
SQLDMOMonth_MinValid = $00000001;
SQLDMOMonth_Sunday = $00000001;
SQLDMOMonth_Monday = $00000002;
SQLDMOMonth_Tuesday = $00000003;
SQLDMOMonth_Wednesday = $00000004;
SQLDMOMonth_Thursday = $00000005;
SQLDMOMonth_Friday = $00000006;
SQLDMOMonth_Saturday = $00000007;
SQLDMOMonth_Day = $00000008;
SQLDMOMonth_WeekDay = $00000009;
SQLDMOMonth_WeekEndDay = $0000000A;
SQLDMOMonth_MaxValid = $0000000A;
// SQLDMO_RUNPRIORITY_TYPE constants
type
SQLDMO_RUNPRIORITY_TYPE = TOleEnum;
const
SQLDMORunPri_Unknown = $00000064;
SQLDMORunPri_Min = $00000001;
SQLDMORunPri_Idle = $FFFFFFF1;
SQLDMORunPri_Lowest = $FFFFFFFE;
SQLDMORunPri_BelowNormal = $FFFFFFFF;
SQLDMORunPri_Normal = $00000000;
SQLDMORunPri_AboveNormal = $00000001;
SQLDMORunPri_Highest = $00000002;
SQLDMORunPri_TimeCritical = $0000000F;
// SQLDMO_NOTIFY_TYPE constants
type
SQLDMO_NOTIFY_TYPE = TOleEnum;
const
SQLDMONotify_None = $00000000;
SQLDMONotify_Email = $00000001;
SQLDMONotify_Pager = $00000002;
SQLDMONotify_NetSend = $00000004;
SQLDMONotify_All = $00000007;
// SQLDMO_ENUMNOTIFY_TYPE constants
type
SQLDMO_ENUMNOTIFY_TYPE = TOleEnum;
const
SQLDMOEnumNotify_Min = $00000001;
SQLDMOEnumNotify_All = $00000001;
SQLDMOEnumNotify_Actual = $00000002;
SQLDMOEnumNotify_Target = $00000003;
SQLDMOEnumNotify_Max = $00000003;
// SQLDMO_JOBEXECUTION_STATUS constants
type
SQLDMO_JOBEXECUTION_STATUS = TOleEnum;
const
SQLDMOJobExecution_Unknown = $00000000;
SQLDMOJobExecution_Executing = $00000001;
SQLDMOJobExecution_WaitingForWorkerThread = $00000002;
SQLDMOJobExecution_BetweenRetries = $00000003;
SQLDMOJobExecution_Idle = $00000004;
SQLDMOJobExecution_Suspended = $00000005;
SQLDMOJobExecution_WaitingForStepToFinish = $00000006;
SQLDMOJobExecution_PerformingCompletionActions = $00000007;
// SQLDMO_FIND_OPERAND constants
type
SQLDMO_FIND_OPERAND = TOleEnum;
const
SQLDMOFindOperand_Unknown = $00000000;
SQLDMOFindOperand_EqualTo = $00000001;
SQLDMOFindOperand_GreaterThan = $00000002;
SQLDMOFindOperand_LessThan = $00000003;
// SQLDMO_JOBSTEPACTION_TYPE constants
type
SQLDMO_JOBSTEPACTION_TYPE = TOleEnum;
const
SQLDMOJobStepAction_Unknown = $00000000;
SQLDMOJobStepAction_QuitWithSuccess = $00000001;
SQLDMOJobStepAction_QuitWithFailure = $00000002;
SQLDMOJobStepAction_GotoNextStep = $00000003;
SQLDMOJobStepAction_GotoStep = $00000004;
// SQLDMO_CATEGORYTYPE_TYPE constants
type
SQLDMO_CATEGORYTYPE_TYPE = TOleEnum;
const
SQLDMOCategoryType_Unknown = $00000000;
SQLDMOCategoryType_LocalJob = $00000001;
SQLDMOCategoryType_MultiServerJob = $00000002;
SQLDMOCategoryType_None = $00000003;
// SQLDMO_TARGETSERVERSTATUS_TYPE constants
type
SQLDMO_TARGETSERVERSTATUS_TYPE = TOleEnum;
const
SQLDMOTargetServerStatus_Unknown = $00000000;
SQLDMOTargetServerStatus_Normal = $00000001;
SQLDMOTargetServerStatus_SuspectedOffline = $00000002;
// SQLDMO_JOB_TYPE constants
type
SQLDMO_JOB_TYPE = TOleEnum;
const
SQLDMOJob_Unknown = $00000000;
SQLDMOJob_Local = $00000001;
SQLDMOJob_MultiServer = $00000002;
// SQLDMO_JOBSERVER_TYPE constants
type
SQLDMO_JOBSERVER_TYPE = TOleEnum;
const
SQLDMOJobServer_StandAlone = $00000001;
SQLDMOJobServer_TSX = $00000002;
SQLDMOJobServer_MSX = $00000003;
SQLDMOJobServer_Unknown = $00000000;
// SQLDMO_ALERT_TYPE constants
type
SQLDMO_ALERT_TYPE = TOleEnum;
const
SQLDMOAlert_SQLServerEvent = $00000001;
SQLDMOAlert_SQLServerPerformanceCondition = $00000002;
SQLDMOAlert_NonSQLServerEvent = $00000003;
// SQLDMO_ERROR_TYPE constants
type
SQLDMO_ERROR_TYPE = TOleEnum;
const
SQLDMO_E_DBLIBFIRSTERROR = $00002710;
SQLDMO_E_DBLIBLASTERROR = $000027D8;
SQLDMO_E_FIRSTERROR = $00005000;
SQLDMO_ECAT_MASK = $00005F00;
SQLDMO_ECAT_INVALIDCONTEXT = $00005000;
SQLDMO_E_ALREADYCONN = $00005000;
SQLDMO_E_ALREADYCOLL = $00005001;
SQLDMO_E_NOTCONN = $00005002;
SQLDMO_E_CANTDROPSERVER = $00005003;
SQLDMO_E_NOCOMPLEXALTER = $00005004;
SQLDMO_E_PROPNEEDSCREATE = $00005005;
SQLDMO_E_COLTYPEFIXED = $00005006;
SQLDMO_E_COLTYPENONNULL = $00005007;
SQLDMO_E_CANTCHANGEUDDT = $00005008;
SQLDMO_E_BASETYPEFIXED = $00005009;
SQLDMO_E_BASETYPENONNULL = $0000500A;
SQLDMO_E_ENUMORDINAL = $0000500B;
SQLDMO_E_CANTRENAMEUSER = $0000500C;
SQLDMO_E_CANTRENAMEGROUP = $0000500D;
SQLDMO_E_CANTRENAMELOGIN = $0000500E;
SQLDMO_E_CANTRENAMEDEVICE = $0000500F;
SQLDMO_E_NOTDUMPPROP = $00005010;
SQLDMO_E_NOSERVERASSOC = $00005011;
SQLDMO_E_NOTCOLLTYPE = $00005012;
SQLDMO_E_CANTMODIFYDRIINDEX = $00005013;
SQLDMO_E_CANTCHANGEPROCTYPE = $00005014;
SQLDMO_E_CANTMODIFYINDEX = $00005015;
SQLDMO_E_INVALIDPRIVOBJ = $00005016;
SQLDMO_E_CANTCHANGETRIGTYPE = $00005017;
SQLDMO_E_NOVIEWCOLALTER = $00005018;
SQLDMO_E_CANTRENAMELANGUAGE = $00005019;
SQLDMO_E_CANTRENAMERSERVER = $0000501A;
SQLDMO_E_CANTRENAMERLOGIN = $0000501B;
SQLDMO_E_MUSTBEDBDEV = $0000501C;
SQLDMO_E_NOINACTIVEMIRROR = $0000501D;
SQLDMO_E_NOACTIVEMIRROR = $0000501E;
SQLDMO_E_NOMIRROR = $0000501F;
SQLDMO_E_SERVERDISCONNECTED = $00005020;
SQLDMO_E_CANTRENAMESERVER = $00005021;
SQLDMO_E_CANTMODIFYTEXT = $00005022;
SQLDMO_E_CANTMODIFYSYSTABLE = $00005023;
SQLDMO_E_LOGINALREADYALIASED = $00005024;
SQLDMO_E_LOGINALREADYUSER = $00005025;
SQLDMO_E_CACHENORESULTS = $00005026;
SQLDMO_E_ALREADYCREATED = $00005027;
SQLDMO_E_NOTDISCONN = $00005028;
SQLDMO_E_CANTMODIFYARTTABLE = $00005029;
SQLDMO_E_PROPERTYCANNOTBEMODIFIED = $0000502A;
SQLDMO_E_BASETYPENOTNUMERIC = $0000502B;
SQLDMO_E_TOFILEBUTNOFILENAME = $0000502C;
SQLDMO_E_MUSTBEDISTSERVER = $0000502D;
SQLDMO_E_CANTMODIFYKEY = $0000502E;
SQLDMO_E_LISTCANTREFRESH = $0000502F;
SQLDMO_E_NOCOLTABLE = $00005030;
SQLDMO_E_MUSTBEINALTER = $00005031;
SQLDMO_E_CANTUNDEDICATELOGDEVICE = $00005032;
SQLDMO_E_CANTRENAMESERVERGROUP = $00005033;
SQLDMO_E_CANTRENAMEREGISTEREDSERVER = $00005034;
SQLDMO_E_INDEXREBUILDKEYTYPE = $00005035;
SQLDMO_E_REBUILDINDEXOPTIONS = $00005036;
SQLDMO_E_IMPERSONATEXPONLY = $00005037;
SQLDMO_E_CANTRENAMEPUBLICATION = $00005038;
SQLDMO_E_CANTMODIFYSPARTTYPE = $00005039;
SQLDMO_E_INVALIDDISTDB = $0000503A;
SQLDMO_E_CANTMODIFYTABLE = $0000503B;
SQLDMO_E_CANTDROPFILEGROUP = $0000503C;
SQLDMO_E_DEFAULTFILEGROUP = $0000503D;
SQLDMO_E_NOTDEFAULTFILEGROUP = $0000503E;
SQLDMO_E_CANTRESETLOGINTYPE = $0000503F;
SQLDMO_E_CANTRESETPASSWORD = $00005040;
SQLDMO_E_PRESQL70 = $00005041;
SQLDMO_E_PROPBEFORECREATE = $00005042;
SQLDMO_E_CANTRENAMEROLE = $00005043;
SQLDMO_E_CANTDROPFIXEDROLE = $00005044;
SQLDMO_E_CANTADDTOAPPROLE = $00005045;
SQLDMO_E_CANTGETROLE = $00005046;
SQLDMO_E_USERDBROLE = $00005047;
SQLDMO_E_FIXEDDBROLE = $00005048;
SQLDMO_E_CANTMODIFYFILTER = $00005049;
SQLDMO_E_INVALIDACTION = $0000504A;
SQLDMO_E_DBOPTION = $0000504B;
SQLDMO_E_USEALTER = $0000504C;
SQLDMO_E_CREATEDBPERM = $0000504D;
SQLDMO_E_CANTCHECKFK = $0000504E;
SQLDMO_E_NOTINMB = $0000504F;
SQLDMO_E_CANTRENAMELSERVER = $00005050;
SQLDMO_E_CANTRENAMELLOGIN = $00005051;
SQLDMO_E_CANTRENAMEFULLTEXT = $00005052;
SQLDMO_E_NOFULLTEXT = $00005053;
SQLDMO_E_ACTIVATEFULLTEXT = $00005054;
SQLDMO_E_NOTFULLTEXTENABLED = $00005055;
SQLDMO_E_CANTDROPLOGFILE = $00005056;
SQLDMO_E_CANTDROPLSLOGIN = $00005057;
SQLDMO_E_SCRIPTPWD = $00005058;
SQLDMO_E_DISTRIBUTORNOTINSTALLED = $00005059;
SQLDMO_E_INVALIDPROPDISTNOTLOCAL = $00005060;
SQLDMO_ECAT_INVALIDOBJECT = $00005100;
SQLDMO_E_OBJECTDROPPED = $00005100;
SQLDMO_E_NOTSQLDMOOBJECT = $00005101;
SQLDMO_E_OBJECTDETACHED = $00005102;
SQLDMO_E_SERVERCLOSED = $00005103;
SQLDMO_ECAT_INVALIDOBJECTDEFINITION = $00005200;
SQLDMO_E_NOCOLUMNSADDED = $00005200;
SQLDMO_E_COLUMNINCOMPLETE = $00005201;
SQLDMO_E_TABLEINCOMPLETE = $00005202;
SQLDMO_E_UDDTINCOMPLETE = $00005203;
SQLDMO_E_RULEINCOMPLETE = $00005204;
SQLDMO_E_DEFAULTINCOMPLETE = $00005205;
SQLDMO_E_VIEWINCOMPLETE = $00005206;
SQLDMO_E_USERINCOMPLETE = $00005207;
SQLDMO_E_GROUPINCOMPLETE = $00005208;
SQLDMO_E_PROCINCOMPLETE = $00005209;
SQLDMO_E_USERALREADYEXISTS = $0000520A;
SQLDMO_E_GROUPALREADYEXISTS = $0000520B;
SQLDMO_E_COLUMNALREADYEXISTS = $0000520C;
SQLDMO_E_OBJECTALREADYEXISTS = $0000520D;
SQLDMO_E_INDEXALREADYEXISTS = $0000520E;
SQLDMO_E_DBALREADYEXISTS = $0000520F;
SQLDMO_E_LOGINALREADYEXISTS = $00005210;
SQLDMO_E_DEVICEALREADYEXISTS = $00005211;
SQLDMO_E_SKIPONLYTAPE = $00005212;
SQLDMO_E_DEVICEINCOMPLETE = $00005213;
SQLDMO_E_PROCALREADYEXISTS = $00005214;
SQLDMO_E_UDDTALREADYEXISTS = $00005215;
SQLDMO_E_TABLEALREADYEXISTS = $00005216;
SQLDMO_E_RULEALREADYEXISTS = $00005217;
SQLDMO_E_DEFAULTALREADYEXISTS = $00005218;
SQLDMO_E_VIEWALREADYEXISTS = $00005219;
SQLDMO_E_INDEXINCOMPLETE = $0000521A;
SQLDMO_E_TRIGINCOMPLETE = $0000521B;
SQLDMO_E_TRIGALREADYEXISTS = $0000521C;
SQLDMO_E_LANGUAGEINCOMPLETE = $0000521D;
SQLDMO_E_LANGUAGEALREADYEXISTS = $0000521E;
SQLDMO_E_LOGININCOMPLETE = $0000521F;
SQLDMO_E_RSERVERINCOMPLETE = $00005220;
SQLDMO_E_RSERVERALREADYEXISTS = $00005221;
SQLDMO_E_NULLRLOGINALREADYEXISTS = $00005222;
SQLDMO_E_RLOGINALREADYEXISTS = $00005223;
SQLDMO_E_REMOTENEEDSLOCAL = $00005224;
SQLDMO_E_BACKUPNEEDSDEVICE = $00005225;
SQLDMO_E_NEEDMANUALFILTERNAME = $00005226;
SQLDMO_E_TASKINCOMPLETE = $00005227;
SQLDMO_E_ARTINCOMPLETE = $00005228;
SQLDMO_E_PUBINCOMPLETE = $00005229;
SQLDMO_E_SUBINCOMPLETE = $0000522A;
SQLDMO_E_ALERTINCOMPLETE = $0000522B;
SQLDMO_E_OPERATORINCOMPLETE = $0000522C;
SQLDMO_E_NAMEMUSTMATCH = $0000522D;
SQLDMO_E_TRIGREQTABLENAME = $0000522E;
SQLDMO_E_MUSTBESYNCTASK = $0000522F;
SQLDMO_E_NOEVENTCOMPLETION = $00005230;
SQLDMO_E_FKEYINCOMPLETE = $00005231;
SQLDMO_E_KEYINCOMPLETE = $00005232;
SQLDMO_E_KEYALREADYEXISTS = $00005233;
SQLDMO_E_CHECKINCOMPLETE = $00005234;
SQLDMO_E_DRIDEFAULTINCOMPLETE = $00005235;
SQLDMO_E_CHECKALREADYEXISTS = $00005236;
SQLDMO_E_ONLYONEPRIMARYKEY = $00005237;
SQLDMO_E_NEEDMANUALVIEWNAME = $00005238;
SQLDMO_E_SERVERGROUPINCOMPLETE = $00005239;
SQLDMO_E_REGISTEREDSERVERINCOMPLETE = $0000523A;
SQLDMO_E_SERVERGROUPALREADYEXISTS = $0000523B;
SQLDMO_E_REGISTEREDSERVERALREADYEXISTS = $0000523C;
SQLDMO_E_NEEDLOADTABLENAME = $0000523D;
SQLDMO_E_DISTDBALREADYEXISTS = $0000523E;
SQLDMO_E_DISTPUBALREADYEXISTS = $0000523F;
SQLDMO_E_JOBSTEPINCOMPLETE = $00005240;
SQLDMO_E_TARGETSERVERINCOMPLETE = $00005241;
SQLDMO_E_TARGETSERVERGROUPINCOMPLETE = $00005242;
SQLDMO_E_JOBINCOMPLETE = $00005243;
SQLDMO_E_MUSTBESYNCJOB = $00005244;
SQLDMO_E_JOBCATEGORYINCOMPLETE = $00005245;
SQLDMO_E_REGPUBINCOMPLETE = $00005246;
SQLDMO_E_REGSUBINCOMPLETE = $00005247;
SQLDMO_E_DISTPUBINCOMPLETE = $00005248;
SQLDMO_E_DISTDBINCOMPLETE = $00005249;
SQLDMO_E_FILEGROUPINCOMPLETE = $0000524A;
SQLDMO_E_DBFILEINCOMPLETE = $0000524B;
SQLDMO_E_LOGFILEINCOMPLETE = $0000524C;
SQLDMO_E_FILEGROUPALREADYEXISTS = $0000524D;
SQLDMO_E_DATABASEINCOMPLETE = $00005250;
SQLDMO_E_DATABASEROLEALREADYEXISTS = $00005251;
SQLDMO_E_DATABASEROLEINCOMPLETE = $00005252;
SQLDMO_E_SERVERROLEINCOMPLETE = $00005253;
SQLDMO_E_DSNINFOINCOMPLETE = $00005254;
SQLDMO_E_FILTERINCOMPLETE = $00005255;
SQLDMO_E_OWNERMUSTMATCH = $00005256;
SQLDMO_E_BACKUPNEEDSFILE = $00005257;
SQLDMO_E_BACKUPNEEDSMEDIA = $00005258;
SQLDMO_E_COLUMNCOMPUTEDINCOMPLETE = $00005259;
SQLDMO_E_REMAPFILEINCOMPLETE = $0000525A;
SQLDMO_E_SMALLMAXSIZE = $0000525B;
SQLDMO_E_FILEALREADYEXISTS = $0000525C;
SQLDMO_E_BADFILEGROUPNAME = $0000525D;
SQLDMO_E_LINKEDSERVERINCOMPLETE = $0000525E;
SQLDMO_E_LINKEDPROVIDERINCOMPLETE = $0000525F;
SQLDMO_E_FULLTEXTINCOMPLETE = $00005260;
SQLDMO_E_CATALOGALREADYEXISTS = $00005261;
SQLDMO_E_CATALOGINCOMPLETE = $00005262;
SQLDMO_E_BACKUPINIT = $00005263;
SQLDMO_E_LINKEDSERVERLOGININCOMPLETE = $00005264;
SQLDMO_E_NOSERVERBCP6 = $00005265;
SQLDMO_ECAT_INVALIDPARAMETER = $00005300;
SQLDMO_E_BADCOLLEN = $00005300;
SQLDMO_E_INVALIDPERFMONSET = $00005301;
SQLDMO_E_BADDEVICETYPE = $00005302;
SQLDMO_E_SIZEGREATERTHAN0 = $00005303;
SQLDMO_E_RESULTSETOUTOFRANGE = $00005304;
SQLDMO_E_OUTPUTPARAMREQUIRED = $00005305;
SQLDMO_E_PROPTEXTNONNULL = $00005306;
SQLDMO_E_BADPROCTYPE = $00005307;
SQLDMO_E_BADFILLFACTOR = $00005308;
SQLDMO_E_INVALIDINDEXTYPE = $00005309;
SQLDMO_E_INVALIDPRIVTYPE = $0000530A;
SQLDMO_E_BADTRIGTYPE = $0000530B;
SQLDMO_E_INVALIDDAYOFWEEK = $0000530C;
SQLDMO_E_INVALIDMONTH = $0000530D;
SQLDMO_E_BADDAYCOUNT = $0000530E;
SQLDMO_E_BADMONTHCOUNT = $0000530F;
SQLDMO_E_BADCONFIGVALUE = $00005310;
SQLDMO_E_INVALIDPARAMINDEX = $00005311;
SQLDMO_E_INVALIDPARAMRANGE = $00005312;
SQLDMO_E_INVALIDDBOBJTYPE = $00005313;
SQLDMO_E_ROWCOLOUTOFRANGE = $00005314;
SQLDMO_E_NONUNIQUENAME = $00005315;
SQLDMO_E_NOTIMESTAMPUDDT = $00005316;
SQLDMO_E_INVALIDNAME = $00005317;
SQLDMO_E_INVALIDCOMPLETION = $00005318;
SQLDMO_E_NAMETOOLONG = $00005319;
SQLDMO_E_INVALIDFREQTYPE = $0000531A;
SQLDMO_E_INVALIDFREQSUBDAY = $0000531B;
SQLDMO_E_INVALIDFREQRELINTERVAL = $0000531C;
SQLDMO_E_BADWEEKLYINTERVAL = $0000531D;
SQLDMO_E_BADMONTHLYINTERVAL = $0000531E;
SQLDMO_E_BADMONTHLYRELINTERVAL = $0000531F;
SQLDMO_E_INVALIDSRVOPTION = $00005320;
SQLDMO_E_INVALIDRUNPRIORITY = $00005321;
SQLDMO_E_DBNAMEREQUIRED = $00005322;
SQLDMO_E_PUBNAMEREQUIRED = $00005323;
SQLDMO_E_PROPINDEXOUTOFRANGE = $00005324;
SQLDMO_E_INVALIDNOTIFYTYPE = $00005325;
SQLDMO_E_INVALIDENUMNOTIFYTYPE = $00005326;
SQLDMO_E_INVALIDWEEKDAY = $00005327;
SQLDMO_E_INVALIDOBJECTTYPE = $00005328;
SQLDMO_E_OBJECTREQUIRED = $00005329;
SQLDMO_E_INVALIDEVENTTYPE = $0000532A;
SQLDMO_E_INVALIDCOMPLETIONTYPE = $0000532B;
SQLDMO_E_INVALIDKEYTYPE = $0000532C;
SQLDMO_E_TABLEMUSTBECREATED = $0000532D;
SQLDMO_E_INVALIDPREARTICLE = $0000532E;
SQLDMO_E_INVALIDSECURITYMODE = $0000532F;
SQLDMO_E_INVALIDPREC = $00005330;
SQLDMO_E_INVALIDDEPENDENCYTYPE = $00005331;
SQLDMO_E_INVALIDVERIFYCONNTYPE = $00005332;
SQLDMO_E_INVALIDSTATUSINFOTYPE = $00005333;
SQLDMO_E_INVALIDFORWARDINGSEVERITY = $00005334;
SQLDMO_E_INVALIDFORWARDINGSERVER = $00005335;
SQLDMO_E_INVALIDRESTARTINTERVAL = $00005336;
SQLDMO_E_INVALIDHISTORYROWSMAX = $00005337;
SQLDMO_E_NAMETOOSHORT = $00005338;
SQLDMO_E_UNEXPECTED = $00005339;
SQLDMO_E_INVALIDHISTORYROWSPERTASKMAX = $0000533A;
SQLDMO_E_INVALIDOBJSORTTYPE = $0000533B;
SQLDMO_E_INVALIDEXECTYPE = $0000533C;
SQLDMO_E_INVALIDSUBSETFILTER = $0000533D;
SQLDMO_E_INCOMPATIBLEPROPS = $0000533E;
SQLDMO_E_FILEPATHREQUIRED = $0000533F;
SQLDMO_E_INVALIDPROPALTER = $00005340;
SQLDMO_E_INVALIDALTERDISTINSTALLED = $00005341;
SQLDMO_E_SERVERNAMEREQUIRED = $00005342;
SQLDMO_E_DISTSERVERNAMEREQUIRED = $00005343;
SQLDMO_E_WORKINGDIRREQUIRED = $00005344;
SQLDMO_E_DISTDBREQUIRED = $00005345;
SQLDMO_E_DISTPUBREQUIRED = $00005346;
SQLDMO_E_INVALIDHISTORYROWSPERJOBMAX = $00005348;
SQLDMO_E_INVALIDPUBATTRIB = $00005349;
SQLDMO_E_INVALIDREPLICATIONTYPE = $0000534A;
SQLDMO_E_INVALIDSCHEMAOPTION = $0000534B;
SQLDMO_E_INVALIDFORREMDISTRIBUTOR = $0000534C;
SQLDMO_E_INVALIDARTICLETYPE = $0000534D;
SQLDMO_E_SIZEGREATERTHANNEG = $0000534E;
SQLDMO_E_INVALIDLOGINTYPE = $0000534F;
SQLDMO_E_CANTMODIFYAFTERCREATE = $00005350;
SQLDMO_E_INVALIDDSN = $00005351;
SQLDMO_E_INVALIDNAME70 = $00005352;
SQLDMO_E_MUSTEVEN = $00005353;
SQLDMO_E_MISSINGALTER = $00005354;
SQLDMO_E_NOTGUID = $00005355;
SQLDMO_E_DESTSERVERREQUIRED = $00005356;
SQLDMO_E_CANTSHRINK = $00005357;
SQLDMO_E_CANTDEFAULTOFF = $00005358;
SQLDMO_E_INVALIDNTNAME = $00005359;
SQLDMO_ECAT_INVALIDPLATFORM = $00005400;
SQLDMO_E_BACKUPSQL60ONLY = $00005400;
SQLDMO_E_MSSQLONLY = $00005401;
SQLDMO_E_WIN95REQUIRESCONN = $00005402;
SQLDMO_E_NOTONWIN95 = $00005403;
SQLDMO_E_SQL60ONLY = $00005404;
SQLDMO_E_REPLSQL60ONLY = $00005405;
SQLDMO_E_STARTUPPROCSQL60ONLY = $00005406;
SQLDMO_E_NEEDSQLDMOPROCS = $00005407;
SQLDMO_E_ALTERSQL60ONLY = $00005408;
SQLDMO_E_SORTEDDATAREORGSQL60ONLY = $00005409;
SQLDMO_E_MSSQLNTONLY = $0000540A;
SQLDMO_E_WIN95REQUIRESSQL60 = $0000540B;
SQLDMO_E_BACKUPSQL65ONLY = $0000540C;
SQLDMO_E_SQL65ONLY = $0000540D;
SQLDMO_E_ALERTSQL65ONLY = $0000540E;
SQLDMO_E_REMOTESQL65ONLY = $0000540F;
SQLDMO_E_PIPEDEVSQL60ONLY = $00005410;
SQLDMO_E_FKEYSQL65ONLY = $00005411;
SQLDMO_E_XPIMPERSONATESQL65ONLY = $00005412;
SQLDMO_E_SQL70ONLY = $00005413;
SQLDMO_E_FKEYSQL70ONLY = $00005414;
SQLDMO_E_BACKUPSQL70ONLY = $00005415;
SQLDMO_E_NEEDSQLDMOUPGRADE = $00005416;
SQLDMO_ECAT_ITEMNOTFOUND = $00005500;
SQLDMO_E_RULENOTFOUND = $00005500;
SQLDMO_E_DEFAULTNOTFOUND = $00005501;
SQLDMO_E_TYPENOTFOUND = $00005502;
SQLDMO_E_LOGINNOTFOUND = $00005503;
SQLDMO_E_GROUPNOTFOUND = $00005504;
SQLDMO_E_LANGNOTFOUND = $00005505;
SQLDMO_E_DBNOTFOUND = $00005506;
SQLDMO_E_DEVICENOTFOUND = $00005507;
SQLDMO_E_COLUMNNOTFOUND = $00005508;
SQLDMO_E_ORDOUTOFRANGE = $00005509;
SQLDMO_E_NAMENOTFOUND = $0000550A;
SQLDMO_E_USERNOTFOUND = $0000550B;
SQLDMO_E_NAMENOTINCACHE = $0000550C;
SQLDMO_E_PROPNAMENOTFOUND = $0000550D;
SQLDMO_E_IDNOTFOUND = $0000550E;
SQLDMO_E_DATABASEROLENOTFOUND = $0000550F;
SQLDMO_E_NAMENOTFOUNDQI = $00005510;
|
|
| Back to top |
|
 |
Wayne Niddery [TeamB] Guest
|
Posted: Sun Apr 25, 2004 3:30 pm Post subject: Re: How to use SqlDMO in Delphi ??? |
|
|
Charles Adriano wrote:
| Quote: | here is a code and sample for SqlDMO (it's free)
|
Charles, this is *far* to long to post in a message and essentially
constitutes an attachment, I must cancel this.
You may repost this *as an attachment to the attachments group*
(borland.public.attachments).
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"True peace is not the absence of tension, but the presence of justice." -
Martin Luther King, Jr.
|
|
| Back to top |
|
 |
Charles Adriano Guest
|
Posted: Sun Apr 25, 2004 7:57 pm Post subject: Re: How to use SqlDMO in Delphi ??? |
|
|
sorry.... in the future i will make this...
charles
"Wayne Niddery [TeamB]" <wniddery (AT) chaffaci (DOT) on.ca> escribió en el mensaje
news:408bd98b$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Charles Adriano wrote:
here is a code and sample for SqlDMO (it's free)
Charles, this is *far* to long to post in a message and essentially
constitutes an attachment, I must cancel this.
You may repost this *as an attachment to the attachments group*
(borland.public.attachments).
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"True peace is not the absence of tension, but the presence of
ustice." -
Martin Luther King, Jr.
|
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|