Helpful Macros (SQL-DMO)

These macros, assisting the C/C++ developer, are defined within Sqldmo.h.

SQLDMOCategory_UseDefault

For the Category property of the Alert, Job, and Operator object, SQL-DMO defines the macro SQLDMOCategory_UseDefault as TEXT("[DEFAULT]"). Use the macro when setting the property, as in:

pAlert->SetCategory(SQLDMOCategory_UseDefault);

SQLDMOTargetServer_Local

For the ApplyToTargetServer and RemoveFromTargetServer methods of the Job object, SQL-DMO defines the macro SQLDMOTargetServer_Local as TEXT("(local)"). Use the macro when altering job execution target, as in:

pJob->ApplyToTargetServer(SQLDMOTargetServer_Local);

SQLDMOAlert_NoJob

For the JobID property of the Alert object, SQL-DMO defines the macro SQLDMOAlert_NoJob as TEXT("00000000000000000000000000000000"). Use the macro to test or change the value of the property.

SQLDMO_ECAT_MASK

SQL-DMO errors enumerated by the SQLDMO_ERROR_TYPE data type are defined as groups of related errors.

SQL-DMO defines the macro SQLDMO_ECAT_MASK as 0x5F00. Use the macro to mask an error returned by SQL-DMO, as in:

// Handle insufficient privilege error.

if (SQLDMO_ECAT_UNPRIVILEGEDLOGIN == (hr & SQLDMO_ECAT_MASK))

{

// Execeptional processing for attempt to perform modification.

}


(c) 1988-98 Microsoft Corporation. All Rights Reserved.