Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Sales. The company has several sales outlets, each having a SQL server 2005 computer. Andrew has to replicate data between the main office and its sales outlets. The database contains several agent profiles to monitor the replication. He wants to modify one of the agent profiles. Which of the following stored procedures will he use to accomplish the task?
A. sp_alter_agent_profile
B. sp_help_agent_profile
C. sp_add_agent_profile
D. sp_modify_agent_profile
Answer:B
Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Sales. The company has several sales outlets, each having a SQL server 2005 computer. Andrew has to replicate data between the main office and its sales outlets. The database contains several agent profiles to monitor the replication. He wants to modify one of the agent profiles. Which of the following stored procedures will he use to accomplish the task?
A. sp_alter_agent_profile B. sp_help_agent_profile C. sp_add_agent_profile D. sp_modify_agent_profile