Role Type Constants (SQLDMO_ROLE_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Role type constants control the output of the ListMembers method of the SQLServer object.
Constant |
Value |
Description |
|---|---|---|
SQLDMORole_All |
3 |
Lists members of server and database roles. |
SQLDMORole_Database |
2 |
Lists members of database roles only. |
SQLDMORole_Server |
1 |
Lists members of server roles only. |