I want to know how sys.sysendpts works for system tables, while Micrcosoft says it only exist in master database only?
It contains a row for each endpoint created in the server.
This exists in the Master Database only.
One thing that this is used by the database engine and not for general user.