SQLNSObjectType constants specify object type definitions.
| Constant | Value | Description |
|---|---|---|
| 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 | 5 | Specific database, SQLNSRootType_Server\ Databases\master |
| SQLNSOBJECTTYPE_DATABASE_DEFAULT | 35 | Specific default |
| 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_PUB_SUBSCRIPTION | 15 | Specific subscription to a publication in a database tree |
| SQLNSOBJECTTYPE_DATABASE_PUBLICATION | 14 | Specific publication in a database tree |
| SQLNSOBJECTTYPE_DATABASE_PUBLICATIONS | 13 | Publications 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_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™ |
| SQLNSOBJECTTYPE_DTS_REPOSPKGS | 83 | DTS packages saved to Microsoft Repository |
| SQLNSOBJECTTYPE_DTSCATEGORIES | 85 | Reserved |
| SQLNSOBJECTTYPE_DTSCATEGORY | 85 | Reserved |
| SQLNSOBJECTTYPE_DTSCONNECTION | 90 | Reserved |
| SQLNSOBJECTTYPE_DTSCONNECTIONS | 88 | Reserved |
| SQLNSOBJECTTYPE_DTS_METADATA | 86 | |
| 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 - 10/07/1998 21:21 |
| SQLNSOBJECTTYPE_ERRORLOGENTRY | 46 | Error log entry, SQLNSRootType_Server\ Management\SQL Server Logs\Current - 10/07/1998 21:21\1998-10-07 20:37:41.40 |
| SQLNSOBJECTTYPE_ERRORLOGS | 44 | Error log folder, SQLNSRootType_Server\ Management\SQL Server Logs |
| SQLNSOBJECTTYPE_INDEXSERVER | 41 | Index server catalog |
| SQLNSOBJECTTYPE_INDEXSERVER_CATOLOG | 43 | Specific index server catalog |
| SQLNSOBJECTTYPE_INDEXSERVER_CATALOGS | 42 | Index server catalog folder |
| 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_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_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_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_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_WEBASSISTANTJOB | 94 | Specific Web Assistant job |
| SQLNSOBJECTTYPE_WEBASSISTANTJOBS | 93 | Web Assistant Jobs |