Check Default profile in use

Displays the profile of a specified agent. This stored procedure is executed at the Distributor on any database.

sp_help_agent_profile

sp_help_agent_profile [ [ @agent_type = ] agent_type ] 
    [ , [ @profile_id = ] profile_id ]

Value

Description

1

Snapshot Agent

2

Log Reader Agent

3

Distribution Agent

4

Merge Agent

9

Queue Reader Agent

use <DistirbutorDatabaseName>
GO
sp_help_agent_profile @agent_type=2
GO

image

Leave a Reply

Your email address will not be published. Required fields are marked *