SQLNSObjectType constants specify object type definitions.
| Constant | Value | Description |
|---|---|---|
| SQLNSOBJECTTYPE _DATABASE | 5 | Specific database, SQLNSRootType_Server\Databases\master. |
| SQLNSOBJECTTYPE_ALERT | 58 | SQLNSRootType_Server\Management\SQL Server Agent\Alerts\Demo: Full msdb log. |
| SQLNSOBJECTTYPE_ALERTS | 47 | SQLNSRootType_Server\Management\SQL Server Agent\Alerts. |
| SQLNSOBJECTTYPE_BACKUPDEVICE | 12 | Specific backup device. |
| SQLNSOBJECTTYPE_BACKUPDEVICES | 11 | Backup Devices. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY | 95 | SQLNSRootType_Server\Management\Current Activity. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_LOCKEDOBJECT | 101 | SQLNSRootType_Server\Management\Current Activity\Locks\Object\master. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_LOCKEDOBJECT_INFO | 102 | SQLNSRootType_Server\Management\Current Activity\Locks\Object\master\1. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_LOCKEDOBJECTS | 100 | SQLNSRootType_Server\Management\Current Activity\Locks\Object. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_LOGIN | 97 | Reserved. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_PROCESSINFO | 98 | SQLNSRootType_Server\Management\Current Activity\Process Info. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_PROCESSINFO_INFO | 99 | SQLNSRootType_Server\Management\Current Activity\Process Info\1. |
| SQLNSOBJECTTYPE_CURRENTACTIVITY_ USERS | 96 | Reserved. |
| SQLNSOBJECTTYPE_DATABASE_DEFAULTS | 34 | Defaults. |
| SQLNSOBJECTTYPE_DATABASE_DIAGRAM | 23 | Internal use only, not exposed. |
| SQLNSOBJECTTYPE_DATABASE_DIAGRAMS | 22 | Database Diagrams. |
| SQLNSOBJECTTYPE_DATABASE_EXTENDED_SP | 31 | Specific extended stored procedure, SQLNSRootType_Server\Databases\master\Extended Stored Procedures\<xp>. |
| SQLNSOBJECTTYPE_DATABASE_EXTENDED_SPS | 30 | Extended stored procedure folder, SQLNSRootType_Server\Databases\master\Extended Stored Procedures. |
| SQLNSOBJECTTYPE_DATABASE_PUBLICATION | 14 | Specific publication in a database tree. |
| SQLNSOBJECTTYPE_DATABASE_PUBLICATIONS | 13 | Publications in a database tree. |
| SQLNSOBJECTTYPE_DATABASE_DEFAULT | 35 | Specific default. |
| SQLNSOBJECTTYPE_DATABASE_PUB_SUBSCRIPTION | 15 | Specific subscription to a publication in a database tree. |
| SQLNSOBJECTTYPE_DATABASE_PULL_SUBSCRIPTION | 17 | Specific pull subscription. |
| SQLNSOBJECTTYPE_DATABASE_PULL_SUBSCRIPTIONS | 16 | Pull subscriptions. |
| SQLNSOBJECTTYPE_DATABASE_ROLE | 21 | Specific database role. |
| SQLNSOBJECTTYPE_DATABASE_ROLES | 20 | Database Roles. |
| SQLNSOBJECTTYPE_DATABASE_RULE | 33 | Specific rule. |
| SQLNSOBJECTTYPE_DATABASE_RULES | 32 | Rules. |
| SQLNSOBJECTTYPE_DATABASE_SP | 29 | Specific stored procedure. |
| SQLNSOBJECTTYPE_DATABASE_SPS | 28 | Stored Procedures. |
| SQLNSOBJECTTYPE_DATABASE_TABLE | 25 | Specific table. |
| SQLNSOBJECTTYPE_DATABASE_TABLES | 24 | Tables. |
| SQLNSOBJECTTYPE_DATABASE_UDDT | 37 | Specific user-defined data type. |
| SQLNSOBJECTTYPE_DATABASE_UDDTS | 36 | User Defined Data Types. |
| SQLNSOBJECTTYPE_DATABASE_UDF | 102 | Specific user-defined function. |
| SQLNSOBJECTTYPE_DATABASE_UDFS | 101 | User-defined Functions folder. |
| SQLNSOBJECTTYPE_DATABASE_USER | 19 | Specific database user. |
| SQLNSOBJECTTYPE_DATABASE_USERS | 18 | Database Users. |
| SQLNSOBJECTTYPE_DATABASE_VIEW | 27 | Specific view, SQLNSRootType_Server\Databases\pubs\Views\titleview. |
| SQLNSOBJECTTYPE_DATABASE_VIEWS | 26 | SQL Server Views, SQLNSRootType_Server\Databases\pubs\Views. |
| SQLNSOBJECTTYPE_DATABASES | 4 | Databases, SQLNSRootType_Server\Databases. |
| SQLNSOBJECTTYPE_DB_MAINT_PLAN | 92 | Specific database maintenance plan. |
| SQLNSOBJECTTYPE_DB_MAINT_PLANS | 91 | Database Maintenance Plans. |
| SQLNSOBJECTTYPE_DTC | 40 | Distributed Transaction Coordinator. |
| SQLNSOBJECTTYPE_DTS_LOCALPKGS | 82 | DTS packages saved to Microsoft® SQL Server™ 2000. |
| SQLNSOBJECTTYPE_DTS_METADATA | 86 | DTS package meta data folder. |
| SQLNSOBJECTTYPE_DTS_REPOSPKGS | 83 | DTS packages saved to repository. |
| SQLNSOBJECTTYPE_DTSCATEGORIES | 85 | Reserved. |
| SQLNSOBJECTTYPE_DTSCATEGORY | 85 | Reserved. |
| SQLNSOBJECTTYPE_DTSCONNECTION | 90 | Reserved. |
| SQLNSOBJECTTYPE_DTSCONNECTIONS | 88 | Reserved. |
| SQLNSOBJECTTYPE_DTSPKG | 86 | Specific DTS package. |
| SQLNSOBJECTTYPE_DTSPKGS | 83 | DTS Packages. |
| SQLNSOBJECTTYPE_DTSSTEP | 89 | Reserved. |
| SQLNSOBJECTTYPE_DTSSTEPS | 87 | Reserved. |
| SQLNSOBJECTTYPE_EMPTY | 1 | Generic object type. |
| SQLNSOBJECTTYPE_ERRORLOG | 45 | Specific error log, SQLNSRootType_Server\Management\SQL Server Logs\Current – Date. |
| SQLNSOBJECTTYPE_ERRORLOGENTRY | 46 | Error log entry, SQLNSRootType_Server\Management\SQL Server Logs\Current – Date and time. |
| SQLNSOBJECTTYPE_ERRORLOGS | 44 | Error log folder, SQLNSRootType_Server\Management\SQL Server Logs. |
| SQLNSOBJECTTYPE_HETEROGENEOUS_PUB_SUBSCRIPTION | 119 | Subscription to a heterogeneous publication. |
| SQLNSOBJECTTYPE_HETEROGENEOUS_PUBLICATION | 118 | Specific heterogeneous publication. |
| SQLNSOBJECTTYPE_HETEROGENEOUS_PUBLICATIONS_FOLDER | 117 | Heterogeneous Publications folder. |
| SQLNSOBJECTTYPE_HETEROGENEOUS_VENDOR_FOLDER | 120 | Heterogeneous Vendors folder. |
| SQLNSOBJECTTYPE_INDEXSERVER | 41 | Index server catalog. |
| SQLNSOBJECTTYPE_INDEXSERVER_CATALOGS | 42 | Index server catalog folder. |
| SQLNSOBJECTTYPE_INDEXSERVER_CATOLOG | 43 | Specific index server catalog. |
| SQLNSOBJECTTYPE_JOBSERVER | 38 | SQL Server Agent. |
| SQLNSOBJECTTYPE_LINKEDSERVER | 61 | Specific linked server, SQLNSRootType_Server\Security\Linked Servers\NWIND. |
| SQLNSOBJECTTYPE_LINKEDSERVER_TABLE | 62 | Linked server table, SQLNSRootType_Server\Security\Linked Servers\NWIND\Tables\Categories. |
| SQLNSOBJECTTYPE_LINKEDSERVER_TABLES | 63 | Linked server table name, SQLNSRootType_Server\Security\Linked Servers\NWIND\Tables. |
| SQLNSOBJECTTYPE_LINKEDSERVERS | 55 | Linked server folder, SQLNSRootType_Server\Security\Linked Servers. |
| SQLNSOBJECTTYPE_LINKEDSERVER_VIEW | 122 | Specific linked server view |
| SQLNSOBJECTTYPE_LINKEDSERVER_VIEWS | 121 | Linked server views folder. |
| SQLNSOBJECTTYPE_LOCAL_JOB | 52 | Specific local job, SQLNSRootType_Server\Management\SQL Server Agent\Jobs\test. |
| SQLNSOBJECTTYPE_LOCAL_JOBS | 50 | Local jobs, SQLNSRootType_Server\Management\SQL Server Agent\Jobs. |
| SQLNSOBJECTTYPE_LOGIN | 10 | Specific user login. |
| SQLNSOBJECTTYPE_LOGINS | 9 | Logins. |
| SQLNSOBJECTTYPE_LOGSHIPPING_MONITOR | 109 | Specific Log Shipping monitor. |
| SQLNSOBJECTTYPE_LOGSHIPPING_MONITORS | 108 | Log Shipping monitor folder. |
| SQLNSOBJECTTYPE_MANAGEMENT | 6 | SQLNSRootType_Server\Management. |
| SQLNSOBJECTTYPE_MSX_JOBS | 49 | Reserved. |
| SQLNSOBJECTTYPE_MULTI_JOB | 53 | Jobs. |
| SQLNSOBJECTTYPE_MULTI_JOBS | 51 | Operators. |
| SQLNSOBJECTTYPE_OPERATOR | 59 | Server Roles. |
| SQLNSOBJECTTYPE_OPERATORS | 48 | Specific SQL Server log. |
| SQLNSOBJECTTYPE_PROFILER | 103 | SQL Server Performance Analysis Traces in the Management folder. |
| SQLNSOBJECTTYPE_PROFILER_TRACE | 104 | Reserved. |
| SQLNSOBJECTTYPE_PUBLICATIONS_FOLDER | 111 | Publications folder in the Replication folder. |
| SQLNSOBJECTTYPE_REMOTESERVER | 60 | Specific server role. |
| SQLNSOBJECTTYPE_REMOTESERVERS | 54 | SQLNSRootType_Server\Security\Remote Servers. |
| SQLNSOBJECTTYPE_REPLICATION | 64 | Replication folder. |
| SQLNSOBJECTTYPE_REPLICATION_AGENTS | 67 | Replication agents folder. |
| SQLNSOBJECTTYPE_REPLICATION_ALERTS | 69 | Replication alerts folder. |
| SQLNSOBJECTTYPE_REPLICATION_DISTRIBUTION_AGENT | 78 | Specific replication Distribution Agent. |
| SQLNSOBJECTTYPE_REPLICATION_DISTRIBUTION_AGENTS | 74 | Replication Distribution Agents folder. |
| SQLNSOBJECTTYPE_REPLICATION_LOGREADER_AGENT | 77 | Specific replication Log Reader Agent. |
| SQLNSOBJECTTYPE_REPLICATION_LOGREADER_AGENTS | 73 | Replication Log Reader Agents folder. |
| SQLNSOBJECTTYPE_REPLICATION_MERGE_AGENT | 79 | Specific replication Merge Agent. |
| SQLNSOBJECTTYPE_REPLICATION_MERGE_AGENTS | 75 | Replication Merge Agents folder. |
| SQLNSOBJECTTYPE_REPLICATION_PUBLICATION | 71 | Specific replication publication. |
| SQLNSOBJECTTYPE_REPLICATION_PUBLISHER | 66 | Specific replication Publisher. |
| SQLNSOBJECTTYPE_REPLICATION_PUBLISHERS | 65 | Replication Publishers folder. |
| SQLNSOBJECTTYPE_REPLICATION_REPORT | 80 | Reserved. |
| SQLNSOBJECTTYPE_REPLICATION_REPORTS | 68 | Reserved. |
| SQLNSOBJECTTYPE_REPLICATION_SNAPSHOT_AGENT | 76 | Specific replication Snapshot Agent. |
| SQLNSOBJECTTYPE_REPLICATION_SNAPSHOT_AGENTS | 72 | Replication Snapshot Agents folder. |
| SQLNSOBJECTTYPE_REPLICATION_SUBSCRIPTION | 70 | Specific replication subscription. |
| SQLNSOBJECTTYPE_REPLICATION_FOLDER | 110 | Replication folder. |
| SQLNSOBJECTTYPE_REPLICATION_FOLDER_PUB_SUBSCRIPTION | 114 | Specific subscription to a publication in the Publications folder. |
| SQLNSOBJECTTYPE_REPLICATION_FOLDER_PUBLICATION | 113 | Specific publication in the Publications folder. |
| SQLNSOBJECTTYPE_REPLICATION_FOLDER_PUSH_SUBSCRIPTION | 116 | Specific push subscription in the Subscriptions folder. |
| SQLNSOBJECTTYPE_REPLICATION_FOLDER_SUBSCRIPTION | 115 | Specific pull subscription in the Subscriptions folder. |
| SQLNSOBJECTTYPE_REPLICATION_MONITOR_GROUP | 105 | Replication monitor group folder. |
| SQLNSOBJECTTYPE_REPLICATION_QUEUEREADER_AGENT | 107 | Specific replication Queue Reader Agent. |
| SQLNSOBJECTTYPE_REPLICATION_QUEUEREADER_AGENTS | 106 | Replication Queue Reader Agents Folder. |
| SQLNSOBJECTTYPE_ROOT | 0 | Generic root node. |
| SQLNSOBJECTTYPE_SECURITY | 7 | Security folder SQLNSRootType_Server\Security. |
| SQLNSOBJECTTYPE_SERVER | 3 | Server. |
| SQLNSOBJECTTYPE_SERVER_GROUP | 2 | Server group. |
| SQLNSOBJECTTYPE_SERVERROLE | 57 | Specific remote server. |
| SQLNSOBJECTTYPE_SERVERROLES | 56 | Remote server folder, SQLNSRootType_Server\Security\Server Roles. |
| SQLNSOBJECTTYPE_SERVICES | 8 | Services folder, SQLNSRootType_Server\Support Services. |
| SQLNSOBJECTTYPE_SQLMAIL | 39 | SQL Mail. |
| SQLNSOBJECTTYPE_SUBSCRIPTIONS_FOLDER | 112 | Subscriptions folder in the Replication folder. |
| SQLNSOBJECTTYPE_WEBASSISTANTJOB | 94 | Specific Web Assistant job. |
| SQLNSOBJECTTYPE_WEBASSISTANTJOBS | 93 | Web Assistant Jobs. |