endpoint name

Question

anyone know how in sql 2005 to get the endpoint names used to create the mirroring?

thanks

Answer 1

I believe these are held in the sys.database_mirroring_endpoints dmv.

You can also go to the endpoints object explorer folder and choose create to script and view the tsql directly.

Answer 2

Adding to Sean,

You can also use sys.endpoints DMV to get that

Below query will help you,

select

name , endpoint_id , type_desc from sys.database_mirroring_endpoints where type_desc='DATABASE_MIRRORING'

select

name from sys.endpoints where type_desc = 'DATABASE_MIRRORING'

---

Thanks, Leks