title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_msx_get_account (Transact-SQL) |
sp_msx_get_account (Transact-SQL) |
markingmyname |
maghan |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Lists information on the credential that the target server uses to log in to the master server.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-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.
Requires membership in 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 AdventureWorks2022\MsxAccount
SQL Server Agent Stored Procedures (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sp_msx_set_account (Transact-SQL)