ProxyAccount.RemoveMsdbRole Method

Removes a Microsoft SQL Server database role from the referenced proxy account.

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

Syntax

'Declaration
Public Sub RemoveMsdbRole ( _
    msdbRoleName As String _
)
'Usage
Dim instance As ProxyAccount 
Dim msdbRoleName As String

instance.RemoveMsdbRole(msdbRoleName)

public void RemoveMsdbRole(
    string msdbRoleName
)

public:
void RemoveMsdbRole(
    String^ msdbRoleName
)

member RemoveMsdbRole : 
        msdbRoleName:string -> unit

public function RemoveMsdbRole(
    msdbRoleName : String
)

Parameters

• msdbRoleName
  Type: System.String
  A String value that specifies the SQL Server database role to be removed.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

ProxyAccount Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_update_proxy (Transact-SQL)