How to start or stop an endpoint in SQL Server

In earlier posts, we learn

• What is End Point in SQL Server? 
• How to create End Point in SQL Server

In this post, we will see how to start or stop a SQL End Point

Let's first query sys.endpoints catalog view and see all the end points exists

select * from sys.endpoints

OUTPUT

To stop an endpoint:

ALTER ENDPOINT endpoint_name STATE = STOPPED

To start an endpoint:

ALTER ENDPOINT endpoint_name STATE = STARTED