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

No comments:

Post a Comment