| title | sp_msx_get_account (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 7b478049-e2d0-4bac-865a-b97fd1d8dfbc | ||
| caps.latest.revision | 20 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Lists information on the credential that the target server uses to log in to the master server.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
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 AdventureWorks2012\MsxAccount
SQL Server Agent Stored Procedures (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sp_msx_set_account (Transact-SQL)