Hi,
I am interested in finding the TCP port which has been setup on a principal/witness/mirror server.
I have queried the sys.database_mirroring_endpoints and sys.endpoints system views but nowhere does it specify the TCP port.
I think the only way to find out is to go to one of the mirrored databases and to right click properties-->Mirroring. I think this is ugly way to find out the TCP port, so if anyones found a better way to find this do tell....
Cheers,
Priyanga
Database Mirroring : How to find the TCP port being used for mirroring?
Hot Topic
- Executing trigger
- ADO.NET Source Custom Properties - Documentation Wrong?
- Bug Report: Expressions not deleted
- increase the speed of the report
- I am unable to install SQL Server 2005 on Win XP SP2 box
- MSmerge_genhistory error-515
- Trying to do too much in a view... I think?
- Cascading Parms
- Upgrade Advisor and retrieving info on a cluster
- How do I return a TRUE or FALSE using a Stored Procedure?
SQL Server
- How can i get the first day of the month and the last day of the month?
- Problem attaching a database
- syncronize two database ?
- Use View to speed up?
- SQL 2005 Standard Replication
- "Server type" is disabled in SQL Server Management Studio
- SQL Transact: Subquery
- MSSQL2005 SP1 setup
- Inserting non english values using jdbc
- MSmerge_genhistory error-515
Database Mirroring : How to find the TCP port being used for mirroring?
DWood
may be what you're looking for...
-Keith.
O_er