sqldmo.h

sql2000 DEVTOOLS INCLUDE

/////////////////////////////////////////////////////////////////////////////////////////
// Header file for SQLDMO C/C++ Client Component Object interfaces.
// Copyright 1994-2000 Microsoft Corporation.
/////////////////////////////////////////////////////////////////////////////////////////


#ifndef _SQLDMO_H_
#define _SQLDMO_H_

// ***************************************************************************
//               Copyright (C) 1985-1999 Microsoft Corporation.
// @File: dmo_itf.h
//
// Purpose: c and c++ object interfaces
//
//
// Notes:
//
// History:
//
//   @Version: Shiloh
//   55901 WG   02/28/00 Copyright
//   52941 WG   01/31/00 UDF and UDDT backward compatible
//   52126 WG   01/19/00 Comments
//   49129 WG   12/07/99 CTS tracking
//
//
// @EndHeader@
// ***************************************************************************


// SQLDMO versions supported for this header file.
#define SQLDMOVERSION_750		0x07320000
#define SQLDMOVERSION_800		0x08000000

// Current version of SQLDMO for this header file (matches sp_MSSQLDMO_version).
// #define SQLDMOVERSION_CURRENT	SQLDMOVERSION_750
#define SQLDMOVERSION_CURRENT	SQLDMOVERSION_800

/////////////////////////////////////////////////////////////////////////////////////////
// Constant enumerations.
/////////////////////////////////////////////////////////////////////////////////////////
#ifndef _SQLDMO_CONSTANTS_
#define _SQLDMO_CONSTANTS_

#ifdef _SQLDMO_ODL_		// Generate helpids if in ODL file.
#define SQLDMO_HELPID(id) [helpcontext(H_##id)]
#else
#define SQLDMO_HELPID(id)
#endif


typedef SQLDMO_HELPID(SQLDMO_OBJECT_TYPE) enum {
	SQLDMOObj_Unknown = 16384,		// Make it the only bit set
	SQLDMOObj_Application = 0,

	// Database objects, value is power(2, sysobjects.sysstat & 0x0f), plus UDDTs in 0.
	// These values can be bitmasked together for object listings.

   // !!! 8.0, UDF is using 1, but 1 has been used by UDDT in pre-80 DMO, due to backward compatible reason,
   // !!! we had to use 4096 for UDF, and swap the value dynamically
   // !!! becasue of this change, the values for SQLDMOObj_AllDatabaseUserObjects, SQLDMOObj_AllDatabaseObjects
   // !!! and SQLDMOObj_AllButSystemObjects are also affected
	SQLDMOObj_UserDefinedDatatype =           0x00000001,    // 1
	SQLDMOObj_SystemTable =                   0x00000002,    // 2
	SQLDMOObj_View =                          0x00000004,    // 4
	SQLDMOObj_UserTable =                     0x00000008,    // 8
	SQLDMOObj_StoredProcedure =               0x00000010,    // 16
	SQLDMOObj_Default =                       0x00000040,    // 64
	SQLDMOObj_Rule =                          0x00000080,    // 128
	SQLDMOObj_Trigger =                       0x00000100,    // 256
	SQLDMOObj_UserDefinedFunction =           0x00001000,    // 4096 (512 - 2048 are used already), this is new for 8.0
                                                            // But power(2, ...) is 1

	SQLDMOObj_AllDatabaseUserObjects =        0x000011fd,    // All but system tables
	SQLDMOObj_AllDatabaseObjects =            0x000011ff,    // All including system tables
	SQLDMOObj_AllButSystemObjects =           0x000013ff,    // All but system objects


// ***************************************************************************
//               Copyright (C) 1985-1999 Microsoft Corporation.
// @File: core_itf.h
//
// Purpose: CORE defines and interfaces
//
//
// Notes:
//
// History:
//
//   @Version: Shiloh
//   65649 IXL  07/08/00 remove job server from job script
//   61175 WG   05/10/00 VIA Netlibs
//   60740 WG   05/08/00 New dboptions for recovery
//   60549 WG   05/01/00 New ServerRole bulkadmin
//   60311 WG   04/27/00 Encrypted UDF checking
//   55928 WG   02/28/00 Compatibility level
//   54473 WG   02/11/00 New script option
//   54427 WG   02/11/00 Restore BackupSetName
//   54311 WG   02/10/00 Extended Property
//   53618 WG   02/03/00 UDF ListPermission
//   53312 WG   01/31/00 Transferrable encryption
//   53089 WG   01/28/00 New Backup Restore option
//   52952 WG   01/27/00 Linked Server option
//   52788 WG   01/26/00 Linked Server options
//   52521 WG   01/24/00 Backup and Restore
//   52513 WG   01/24/00 GrantedGranted
//   52356 WG   01/21/00 ProductLevel
//   51928 WG   01/18/00 EnumAvailableMedia
//   51899 WG   01/18/00 DatabaseRole
//   51623 WG   01/17/00 IsDeleted
//   51534 WG   01/13/00 CheckSyntax
//   50625 WG   01/04/00 Syntax check for default and rule
//   50559 WG   01/03/00 Language ID on fulltext column
//   50447 WG   12/29/99 EnumDependencies with system objects
//   49768 WG   12/14/99 Support bigint in QueryResult
//   49712 WG   12/13/99 Refresh for LinkedServer
//   49522 WG   12/10/99 Script Job with enable flag
//   49452 WG   12/10/99 EnumParameters for UDF
//   49129 WG   12/07/99 CTS tracking
//
//
// @EndHeader@
// ***************************************************************************




        // Other Database objects (not in sysobjects)
        SQLDMOObj_SystemDatatype =                0x00001000,
        SQLDMOObj_User =                          0x00002000,
        SQLDMOObj_Group =                         0x00003000,
        SQLDMOObj_Index =                         0x00004000,
        SQLDMOObj_Key =                           0x00005000,
        SQLDMOObj_Column =                        0x00006000,
        SQLDMOObj_DBObject =                      0x00007000,
        SQLDMOObj_DBOption =                      0x00008000,
        SQLDMOObj_ProcedureParameter =            0x00009000,
        SQLDMOObj_Permission =                    0x0000A000,
        SQLDMOObj_IntegratedSecurity =            0x0000B000,
        SQLDMOObj_Check =                         0x0000C000,
        SQLDMOObj_DRIDefault =                    0x0000D000,

        // Objects not in databases.
        SQLDMOObj_SQLServer =                     0x00020000,
        SQLDMOObj_Database =                      0x00021000,
        SQLDMOObj_BackupDevice =                  0x00022000,
        SQLDMOObj_Login =                         0x00023000,
        SQLDMOObj_Language =                      0x00024000,
        SQLDMOObj_RemoteServer =                  0x00025000,
        SQLDMOObj_RemoteLogin =                   0x00026000,
        SQLDMOObj_Configuration =                 0x00027000,
        SQLDMOObj_ConfigValue =                   0x00028000,
        SQLDMOObj_QueryResults =                  0x00029000,
        SQLDMOObj_TransactionLog =                0x0002A000,
        SQLDMOObj_Registry =                      0x0002B000,
        SQLDMOObj_Transfer =                      0x0002C000,
        SQLDMOObj_Backup =                        0x0002D000,
        SQLDMOObj_AutoProperty =                  0x0002E000,
        SQLDMOObj_ServerGroup =                   0x0002F000,
        SQLDMOObj_RegisteredServer =              0x00031000,
        SQLDMOObj_BulkCopy =                      0x00032000,
        SQLDMOObj_FileGroup =                     0x00033000,
        SQLDMOObj_DBFile =                        0x00034000,
        SQLDMOObj_LogFile =                       0x00035000,
        SQLDMOObj_ServerRole =                    0x00036000,
        SQLDMOObj_DatabaseRole =                  0x00037000,
        SQLDMOObj_Restore =                       0x00038000,
        SQLDMOObj_LinkedServer =                  0x00039000,
        SQLDMOObj_LinkedServerLogin =             0x00040000,
        SQLDMOObj_FullTextCatalog =               0x00041000,
        SQLDMOObj_FullTextService =               0x00042000,








   // Replication Objects
	SQLDMOObj_TransPublication =      		0x00101000,
	SQLDMOObj_TransArticle =          		0x00102000,
	SQLDMOObj_TransSubscription =     		0x00103000,
	SQLDMOObj_TransPullSubscription =		0x00104000,
	SQLDMOObj_MergePublication =         	0x00105000,
	SQLDMOObj_MergeArticle = 				0x00106000,
	SQLDMOObj_MergeSubscription =        	0x00107000,
	SQLDMOObj_MergePullSubscription =		0x00108000,
	SQLDMOObj_Replication =                 0x00109000,
	SQLDMOObj_Publisher =                   0x0010A000,
	SQLDMOObj_Subscriber =                  0x0010B000,
	SQLDMOObj_Distributor =                 0x0010C000,
	SQLDMOObj_ReplicationSecurity =         0x0010D000,
	SQLDMOObj_DistributionPublisher =       0x0010E000,
	SQLDMOObj_RegisteredSubscriber =        0x0010F000,
	SQLDMOObj_ReplicationDatabase =         0x00110000,
	SQLDMOObj_DistributionDatabase =        0x00111000,
	SQLDMOObj_ReplicationTable =            0x00112000,
	SQLDMOObj_ReplicationStoredProcedure =  0x00113000,
	SQLDMOObj_DistributionPublication =     0x00114000,
	SQLDMOObj_DistributionArticle =         0x00115000,
	SQLDMOObj_DistributionSubscription =    0x00116000,
	SQLDMOObj_MergeSubsetFilter = 			0x00117000,
    SQLDMOObj_MergeDynamicSnapshotJob =     0x00118000,




// ***************************************************************************
//               Copyright (C) 1985-1999 Microsoft Corporation.
// @File: agen_itf.h
//
// Purpose: Agent defines and interfaces
//
//
// Notes:
//
// History:
//
//   @Version: Shiloh
//   49246 WG   12/07/99 CTS tracking
//
//
// @EndHeader@
// ***************************************************************************




   // SQL JobServer Objects
        SQLDMOObj_AlertSystem =                   0x00201000,
        SQLDMOObj_JobServer =                     0x00202000,
        SQLDMOObj_Alert =                         0x00203000,
        SQLDMOObj_Operator =                      0x00204000,
        SQLDMOObj_Job =                           0x00205000,
        SQLDMOObj_JobStep =                       0x00206000,
        SQLDMOObj_TargetServer =                  0x00207000,
        SQLDMOObj_TargetServerGroup =             0x00208000,
        SQLDMOObj_Category =                      0x00209000,
        SQLDMOObj_Schedule =                      0x00210000,
        SQLDMOObj_JobFilter =                     0x00211000,
        SQLDMOObj_JobHistoryFilter =              0x00212000,
        SQLDMOObj_JobSchedule =                   0x00213000,