• One recommendation for script #4 would be to explain how to use sp_help_agent_profile to determine the correct @profile_id for sp_add_agent_parameter. It appears that you are supplying the agent_type value rather than the profile_id value for the subsequent calls to sp_add_agent_parameter. Some of those values may be the same, some may not. This is especially true if you decide to create custom agent profiles for the replicaiton topologies that use mirroring (which is the best practice I call out in my book).


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]