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 […]