sp_msx_get_account (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_msx_get_account  

Return Code Values

0 (success) or 1 (failure)

Result Sets

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.

Remarks

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

Permissions

Requires membership in the sysadmin fixed server role.

Examples

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 AdventureWorks2012\MsxAccount

See Also

SQL Server Agent Stored Procedures (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sp_msx_set_account (Transact-SQL)