MSagent_profiles (Transact-SQL)
The MSagent_profiles table contains one row for each defined replication agent profile. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
|
profile_id |
int |
The profile ID. |
|
profile_name |
sysname |
The unique profile name for agent type. |
|
agent_type |
int |
The type of agent: 1 = Snapshot Agent 2 = Log Reader Agent 3 = Distribution Agent 4 = Merge Agent 9 = Queue Reader Agent |
|
type |
int |
The type of profile: 0 = System1 = Custom |
|
description |
nvarchar(3000) |
The description of the profile. |
|
def_profile |
bit |
Specifies whether this profile is the default for this agent type. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables
