sp_help_agent_profile (Transact-SQL)
Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.
|
Column name |
Data type |
Description |
|---|---|---|
|
profile_id |
int |
ID of the profile. |
|
profile_name |
sysname |
Unique for agent type. |
|
agent_type |
int |
1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent 9 = Queue Reader Agent |
|
Type |
int |
0 = System 1 = Custom |
|
description |
varchar(3000) |
Description of the profile. |
|
def_profile |
bit |
Specifies whether this profile is the default for this agent type. |
