sp_msx_get_account (Transact-SQL)
Lists information on the credential that the target server uses to log in to the master server.
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. |
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
Reference
CREATE CREDENTIAL (Transact-SQL)sp_msx_set_account (Transact-SQL)
