Using Catalog Views and System Stored Procedures
SQL Server provides a set of stored procedures and catalog views directly related to endpoint functionality. With them, you can find out anything you need to know about what endpoints exist on the server, the states they are in, the web methods associated with them, the settings used in their DDL, and so on.
To get a result set of all the registered endpoints for a server, you execute the following simple T-SQL statement against sys.endpoints in a new query window in the context of the master database:
As the result set illustrates, listeners for the basic SQL Server network protocols (for example, ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
