This topic has not yet been rated - Rate this topic

ProxyAccount.EnumMsdbRoles Method

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008
SQL Server 2005

Enumerates a list of Microsoft SQL Server database roles associated with the referenced proxy account.

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public DataTable EnumMsdbRoles()

Return Value

Type: System.Data.DataTable
A DataTable object value that contains a table of information about the SQL Server database roles that are associated with the referenced proxy account.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

ProxyAccount Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_help_proxy (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD