Showing posts with label endpoint. Show all posts
Showing posts with label endpoint. Show all posts

Monday, March 19, 2012

How to detect an EndPoint is existed or not?

How to detect an EndPoint is existed or not?
I would like to detect it before drop an endpoint.
--FrankYou can check sys.endpoints to see if it exists.
IF EXISTS ( SELECT * FROM sys.endpoints WHERE name = 'my_endpoint' )
Anith|||"Anith Sen" <anith@.bizdatasolutions.com> glsD:e%23YJwf4QGHA.3916@.TK2MSFTNGP11.phx
.gbl...
> You can check sys.endpoints to see if it exists.
> IF EXISTS ( SELECT * FROM sys.endpoints WHERE name = 'my_endpoint' )
>
I got it.
Thanks