Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_msx_get_account (Transact-SQL)

Lists information on the credential that the target server uses to log in to the master server.

Topic link iconTransact-SQL Syntax Conventions

sp_msx_get_account

0 (success) or 1 (failure)

Returns the following result set:

Column Name

Type

Description

msx_connection

int

Master server connection number.

msx_credential_id

int

ID of the credential used for this master server connection.

msx_credential_name

sysname

Name of the credential used for this master server connection.

msx_login_name

nvarchar(4000)

Domain name and user name of the Windows user for the credential.

Returns an empty result set if there is no credential specified for this target server. To set the credential use, sp_msx_set_account.

Execute permissions for sp_msx_get_account default to members of the sysadmin fixed server role.

The following example lists information for the credential that this target server uses to log in to the master server.

USE msdb ;
GO

EXECUTE dbo.sp_msx_get_account ;
GO

Here is a sample result set:

msx_connection msx_credential_id msx_credential_name  msx_login_name
-------------- ----------------- -------------------- ------------------------------
1              65538             MsxAccount           AdventureWorks\MsxAccount
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.