SQLNSObjectType

SQL-NS

SQL-NS

SQLNSObjectType

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.